3

Can someone please point me in the right direction of how I can connect to MS SQL Server with Python? What I want to do is read a text file, extract some values and then insert the values from the text file into a table in my Sql Server database. I am using Python 3.1.3, and it seems some of the modules I have come across in research online are not included in the library. Am I missing something? Is there a good 3rd party module I should know about. Any help would be greatly appreciated.I am using Windows. thanks

Improve this question
1
  • 1
    Specify from which platform do you want to connect to MS SQL Server, I think that there is no native Python-SQL Server connector. Commented May 27, 2011 at 15:01

3 Answers 3

Reset to default
3

There are a bunch more SQL Server libraries listed on the Python wiki. At least mxODBC is fully ready for Python 3.1, but I haven't used it so I can't comment on its appropriateness...

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

Comments

1

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

Improve this answer

3 Comments

It looks like this module does not work with versions of python after 2.6 so far.
Yes: "there is work in progress to support Python 3.0 and 3.1". I've found one more connector: link, how-to, one more link
Here is using mssql from within python 2.5, but the article has been written in 2007, that's why may be Python 3 support
1

I found a module called CEODBC that I was able to use with Python 3 after doing some research. It looks like they will also be releasing a Python3 compatible version of PYODBC soon. Thanks for all your help.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.