Geek asks and answers

Connect to Sql server using Python 3 on Windows

Can someone point me in the right direction, how can I connect to MS SQL Server with Python? I want to read a text file, extract some values, and then paste the values ​​from the text file into a table in my Sql Server database. I am using Python 3.1.3, and it looks like some of the modules I found in online research are not included in the library. Am I missing something? Is there a good third-party module that I should be aware of. Any help would be greatly appreciated. I am using windows. thank

+3
source share
3 answers

There is another group of SQL Server libraries listed on the Python wiki . At least mxODBC is completely ready for Python 3.1, but I have not used it, so I can not comment on its usefulness ...

+3
source

There is a pymssql module . Here you can find the installation instructions

+1
source

I found a module called CEODBC that I was able to use with Python 3 after some research. It looks like they will soon release a Python3 compatible version of PYODBC. Thank you for your help.

+1
source

More articles:


All Articles