[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