Python3 connecting to MSSQL

Question

I am writing Python3 and we have a database(mssql). I have some strings and want to put these strings into db table. But I could not handle connecting to DB. Some people suggested using pyodbc but my python version is 3.4.4 and pyodbc is not supporting it. I am writing my codes in PyCharm IDE and I am not using anyother IDE such as Visual Studio, Eclipse, etc. DB is created and the table exists.

Which programs or libraries do I need?
Which lines that I should write to code (like import pypmssql)

Language: Python3 version 3.4.4 IDE: PyCharm latest version DB: MSSQL

Did you look here? docs.sqlalchemy.org/en/latest/dialects/mssql.html — advance512
– advance512, Commented Jun 21, 2016 at 14:27

manzerbredes · Accepted Answer · 2016-06-21 14:27:57Z

1

If you work on a Linux distribution, try to install pip3 (python dependency manager for python 3) then run

pip install pymssql

Then read the library documention to learn how to use it at http://pymssql.org/en/latest/

answered Jun 21, 2016 at 14:27

manzerbredes

3202 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

abidinberkay Over a year ago

Connection is timed out :( It is probably due to my network access privileges. Is there anyother way ? I tried to download it manually from pypi.python.org/pypi/pymssql/2.1.2#downloads but I do not know how to install the downloaded md5 file

manzerbredes Over a year ago

Try to download the whl file from pypi.python.org/pypi/pymssql/2.1.2#downloads then run pip3 install pymssql-2.1.2-cp27-cp27m-win32.whl

abidinberkay Over a year ago

pymssql-2.1.2-cp34-cp34m-win32.whl is not a supported wheel on this platform.

manzerbredes Over a year ago

Try to download another file format (you have downloaded the win32 version)

abidinberkay Over a year ago

I tried all of them in pypi.python.org/pypi/pymssql/2.1.2#downloads but not working :( always saying wheel is not supported on this platform

|

Collectives™ on Stack Overflow

Python3 connecting to MSSQL

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related