FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

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