FreeTDS Development Group

[Dominic Smith <d.smith AT querix.co.uk>]

Thanks - absolutely right there. Switching to 7.0 works fine. Somehow, the 
painfully obvious becomes invisible from time to time.

 > tsql uses the TDS version specified in your freetds.conf or, failing that,
 > $TDSVER in your environment, or the compiled-in default.  It appears tsql
 > is connecting with TDS 4.2 and ODBC is failing to connect with TDS 5.0.  

 > See the UG for a table of which servers use what version of the TDS
 > protocol.  

 > HTH.

 > --jkl
 > _______________________________________________
 > FreeTDS mailing list
 > FreeTDS AT lists.ibiblio.org
 > http://lists.ibiblio.org/mailman/listinfo/freetds




---------- Original Message ----------

FROM:      "James K. Lowden" <jklowden AT freetds.org>
TO:        FreeTDS Development Group <freetds AT lists.ibiblio.org>
DATE:      Wed, 26 Sep 2007 13:50:47 -0400

SUBJECT:   Re: [freetds] ODBC connection problem

Dominic Smith wrote:
> Using either unixODBC or iODBC driver managers, connecting to SQL Server
> 2000  hosted on XP/SP2 from Redhat 7.3 (glibc 2.2.5). The connection
> seems to work  fine from tsql, but consistently fails from odbc....
...
> In the odbc.ini file, the DSN is defined as:
> 
> [sqlserver]
> Driver=/imports/resources/ODBC/32/lnx/libtdsodbc.so
> Description=SQL Server on columbia
> Server=columbia
> Database=stores
> Port=1433
> TDS_Version=5.0
             ^^^ Not supported by Microsoft

tsql uses the TDS version specified in your freetds.conf or, failing that,
$TDSVER in your environment, or the compiled-in default.  It appears tsql
is connecting with TDS 4.2 and ODBC is failing to connect with TDS 5.0.  

See the UG for a table of which servers use what version of the TDS
protocol.  

HTH.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds