[DB-SIG] mxODBC and MS SQL Server

M.-A. Lemburg mal@lemburg.com
Fri, 16 Jul 1999 10:11:35 +0200

Just thought, I'd inform you of an inconvenience that occurs
when using mxODBC to access MS SQL Server.

The ODBC driver of SQL Server does not LONG columns to appear
anywhere but the end of a SELECT columns list, e.g.
SELECT anInteger, aString, aLONG FROM ... will work, but
SELECT aString, aLONG, anInteger FROM ... won't.

For now the work-around is simple: always put LONG columns at the
end of the SELECT column list.

The next version of mxODBC will include a fix for this.

BTW, using the EasySoft ODBC bridge, you can now even access
MS SQL Server running on a WinNT from any Unix machine, e.g.
your web-server or Python development machine.

More infos on mxODBC and all of the above can be found at:


Marc-Andre Lemburg
Y2000:                                                   168 days left
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/