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

[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