Someone help please!
I would like to port data to MS SQL with Python. Does someone know how to do that? I've checked MySQL etc, and got a product called mxODBC that could talk to MS Access, but that seems to be rather clumsy. I would like to work directly with MS SQL via ODBC from Python. Now who has done this before?
I would really appreciate it if someone can shed some light on this matter.
You don't need mxODBC. All you need are the win32 extensions for python installed.
http://starship.python.net/crew/mhammond/win32/Downloads.html
Here is an example of how to use them:http://www.python.org/windows/win32/odbc.html
Of course this will only work on windows. There should be an equivalent for Unix, anyone else want to comment on that? Also, I realize there are some ODBC classes for wxWidgets, but I never got them to work in python.
good luck,
Matt
You can also use ADO
Hey scropy, do you still have the link to your article on ADO? Wouldn't mind reading though it again.
Mark.
Heh, my webhost is having trouble and my website is down. I do have a mirror running from home, but you'll need to edit your hosts file to get to it. Please PM me for instructions, if you want to read the article now, or wait a few days till they resolve the problem. :).
All right! My webhost just resolved their issues. If you're interested, my ADO and python article is here:
http://www.mayukhbose.com/python/ado/index.php
What's the most efficient way(cost and library indepence) to connect to mssql? Also, I'm trying to connect to the database on a solaris box. Is there a good way of doing this?