FreeTDS vs Inline TDS: Problem with Inline TDS

Sandeep Gupta sandeep182 at hotmail.com
Thu Jun 20 11:12:48 EDT 2002


I'm attempting to access a SQL Server 2000 DB from Linux using ODBC.  My
setup is
Python --> mxODBC --> unixODBC --> <ODBC Driver> --> SQL Server

When I use the Inline TDS driver directly from unixODBC, all queries return
the correct results, but the final line is always "-1 rows affected".  The
FreeTDS driver returns the correct results as well as the correct number of
rows affected.  The incorrect "rows affected" from Inline TDS seems to be
causing problems with mxODBC.

Has anyone experienced this same problem with Inline TDS's driver?

Are there any other suggestions for querying against SQL Server 2000 from
Python running on Linux?

Thanks
Sandeep





More information about the Python-list mailing list