[freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails

Boniforti Flavio flavio at piramide.ch
Wed Dec 1 02:42:39 EST 2010

Hello everybody.

I'm trying to get my Linux Server connecting to my MSSQL 2005 Express
database, and so far I got it only partially working.
I followed the instructions I found here:

When I use tsql, I get my connection working, instead by using isql I

root at ticket:~# isql -v sqlexpress sa
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect

My /etc/odbc.ini:

Driver          = FreeTDS
Port            = 1433
Description     = MS SQL Server 2005 Express
Trace           = Yes
Servername      = exchange.piramide.local
Database        = Piramide_Informatica

My /etc/odbcinst.ini:

Description     = Free Sybase & MS SQL Driver
Driver          = /usr/lib/odbc/libtdsodbc.so
Setup           = /usr/lib/odbc/libtdsS.so
UsageCount      = 1

Is there any way to get around this error? Where am I wrong?

Thanks and kind regards.

Flavio Boniforti

Via Ballerini 21
6600 Locarno
Phone: +41 91 751 68 81
Fax: +41 91 751 69 14
URL: http://www.piramide.ch
E-mail: flavio at piramide.ch 

More information about the FreeTDS mailing list