Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Boniforti Flavio" <flavio AT piramide.ch>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
  • Date: Wed, 1 Dec 2010 17:08:45 +0100

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@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@ticket:~# locate ld-linux.so.2
/lib/ld-linux.so.2
/lib/i686/cmov/ld-linux.so.2

Using strace I got:

root@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




Archive powered by MHonArc 2.6.24.

Top of Page