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

[perlraj]

Hi I have a problem with connecting MSSQL Server using FreeTDS
I am using Ubuntu 12.04 LTS
I have installed unixODBC in the path /usr/local/unixODBC and freeTDS in /usr/local/freeTDS and got all the files like odbc.ini, odbcinst.ini and freetds.conf in the path /etc
i am trying to connect with DNS less connection following the instructions from the link

www.freetds.org/userguide/dsnless.htm

I am getting the error [unixODBC][FreeTDS][SQL Server] Unable to connect to data source (SQL-08001)

Driver config file odbcinst.ini
[FreeTDS]
Driver=/usr/local/freetds/lib/libtdsodbc.so
Setup=/usr/local/freetds/lib/libtdsodbc.so
Threading=0
FileUsage=1
DontDLClose=1

Perl Program
#!/usr/bin/perl
use strict;
use DBI;

$dsn = "dbi:ODBC:DRIVER={FreeTDS};Server=$server;database=$database;";
$dbh = DBI->connect("$dsn","$user","$password") or die "\n$DBI::errstr
+\n";

[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

[tobyink]

For what it's worth, I've had a lot more luck using DBD::Sybase to connect to MSSQL servers than ODBC.

[karlgoethebier]

...but as far as i remember, don't you need also FreeTDS when connecting to MSSQL with DBD::Sybase?

Regards, Karl

[tobyink]

Indeed you do.