FreeTDS vs Inline TDS: Problem with Inline TDS

Sat Apr 5 13:59:51 EST 2003

On Thu, 20 Jun 2002 15:12:48 +0000, Sandeep Gupta wrote:

> 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
You may try
 http://www.object-craft.com.au/projects/sybase/
compiled with FreeTDS. It does not allow parameters in queries AFAIK. You
may ask at the db-sig list to get more precise answers.