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

Boniforti Flavio flavio at piramide.ch
Wed Dec 1 11:08:45 EST 2010


Hello Peter.

> Start by using the unixODBC tool "osql" which is a shell 
> script which tries to discover the correct parameters to pass to isql.

My /etc/odbc.ini:

[sqlexpress]
Driver          = FreeTDS
#Driver          = /usr/lib/odbc/libtdsodbc.so
Port            = 1433
Description     = MS SQL Server 2005 Express
Trace           = Yes
Server          = exchange.piramide.local
Database        = Piramide_Informatica

Then I try to connect with osql:

root at ticket:~# osql -S sqlexpress -U sa -P XXXXXX
osql: error: no potential directory strings in "/usr/bin/isql"
isql strings are:
+ /lib/ld-linux.so.2

The latter file *does exist*:

root at ticket:~# locate ld-linux.so.2
/lib/ld-linux.so.2
/lib/i686/cmov/ld-linux.so.2

Using strace I got:

root at ticket:~# strace -e connect osql -S sqlexpress -U sa -P cheope
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
osql: error: no potential directory strings in "/usr/bin/isql"
isql strings are:
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
+ /lib/ld-linux.so.2
--- SIGCHLD (Child exited) @ 0 (0) ---

Where may the problem be?

Thanks again.
Flavio Boniforti

PIRAMIDE INFORMATICA SAGL
Via Ballerini 21
6600 Locarno
Switzerland
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