Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC connection problem
  • Date: Wed, 26 Sep 2007 13:50:47 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page