freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] connecting to MSSQL Server 2005

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] connecting to MSSQL Server 2005
Date: Wed, 30 Jul 2008 17:30:16 -0400

Horacio Nuñez Hernández wrote:
> Im running Debian Etch with unixODBC and tdsodbc 0.63,
...
> Diag(hdbc 0x821fee8):08001:0:[unixODBC][FreeTDS][SQL Server]Unable to
> connect to data source SQLConnect() failed
>
> What I can do, should move to .82?

Upgrading would be helpful. The newer release includes many improvements.
Have a look at the README, NEWS, and ChangeLog for more information.

But 0.63 can connect to your server. Try TDSDUMPCONFIG, and pay special
attention to your ODBC configuration. If you're not using ODBC-Combined,
take care to set your TDS version to 7.0.

HTH.

--jkl

[freetds] connecting to MSSQL Server 2005, Horacio Nuñez Hernández, 07/30/2008
- Re: [freetds] connecting to MSSQL Server 2005, James K. Lowden, 07/30/2008