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: Dominic Smith <d.smith AT querix.co.uk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC connection problem
  • Date: Thu, 27 Sep 2007 10:30:55 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page