[DB-SIG] Linux, ODBC and MSSQL
mal at egenix.com
Fri Nov 19 20:13:00 CET 2004
Eric Brunson wrote:
> I've been tossed into a data conversion where it would be *extremely*
> convenient to connect to a MSSQL server running on Windows 2000 from my
> Linux workstation.
> I've researched to software available and I have freetds and the Sybase
> module based on it installed as well as mxODBC to try to use with ADODB,
> but I'm having trouble understanding how to address the database.
> I found a couple of references to using the NT name of the box as the
> host, but do I have so have some sort of WINS resolution enabled for that
> to work?
> If anyone can give some insight, I'd be very appreciative.
Try this route:
Python -> mxODBC -> unixODBC -> FreeTDS ODBC driver -> MS SQL
You should first install unixODBC, then the FreeTDS driver,
check that it works using the unixODBC isql tool and then
install mxODBC to talk to the unixODBC manager.
Note: ADODB doesn't work on Linux, only on Windows.
Professional Python Services directly from the Source (#1, Nov 19 2004)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
More information about the DB-SIG