[DB-SIG] Linux, ODBC and MSSQL

M.-A. Lemburg 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.

Marc-Andre Lemburg

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 mailing list