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

[karlgoethebier]

FreeTDS comes with some useful tools for debugging. Please take a look at Troubleshooting ODBC connections.

Regards, Karl

[perlraj]

Hi Thanks a lot

My odbc.ini

[SQLServer]
Driver=/usr/local/freetds/lib/libtdsodbc.so
Description=SQL Server DSN created during installation
Server=10.101.11.87
Port=1433
User=
Password=
Language=
Database=
Logging=0
LogFile=
QuotedId=Yes
AnsiNPW=Yes
Mars_Connection=No

But I am getting the error when i execute the command

$ osql -S servername -U username -P password

checking shared odbc libraries linked to isql for default directories.
+..
    trying /usr ... no
    trying /loc ... no
    trying /tmp/sql.log ... no
    trying /home ... no
    trying /.odbc.ini ... no
    trying /usr/local/etc ... OK
checking odbc.ini files
    reading /home/perlzuser/.odbc.ini
[10.101.11.87] not found in /home/perlzuser/.odbc.ini
    reading /usr/local/etc/odbc.ini
[10.101.11.87] found in /usr/local/etc/odbc.ini
found this section:
looking for driver for DSN [10.101.11.87] in /usr/local/etc/odbc.ini
  no driver mentioned for [10.101.11.87] in odbc.ini
looking for driver for DSN [default] in /usr/local/etc/odbc.ini
osql: error: no driver found for [10.101.11.87] in odbc.ini

[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