Re^3: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)

[karlgoethebier]

osql: error: no driver found for [10.101.11.87] in odbc.ini

...something is wrong with your configuration ;-)

I don't use FreeTDS, it's new to me - but i've just read the manual a bit and by search i found this:

/etc $ cat freetds.conf
[SERVER]
  host = 192.168.0.10
  port = 1433
  tds version = 7.0

/etc$ cat odbcinst.ini
[FreeTDS]
Description     = TDS driver (Sybase/MS SQL)
Driver          = /usr/lib/odbc/libtdsodbc.so
Setup           = /usr/lib/odbc/libtdsS.so
CPTimeout       =
CPReuse         =
FileUsage       = 1

/etc$ cat odbc.ini
[SERVER]
Driver          = FreeTDS
Description     = ODBC connection via FreeTDS
Trace           = No
Servername      = SERVER
Database        = DATABASE

Differences i can see:

1. No database in your odbc.ini
2. In your odbcinst.ini Setup is the same as Driver (don't know if this matters)

Not very much, but perhaps it helps a bit to get ahead.

Update: The FreeTSD Archives

Regards, Karl