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

Sankar G <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAJkiSB4+QTikp=BC5q104pAiT+Mx4RW2xAa8M-HONxyV48T_Rg@mail.gmail.com>
Hi

I am getting some errors when i am trying to connect MS SqlServer using
FreeTDS,
unixODBC and DBD::ODBC.

My odbcinst.ini file

[FreeTDS]
Description = TDS driver (Sysbase/MS SQL)
Driver = /usr/local/freetds/lib/libtdsodbc.so
Setup = /usr/local/freetds/lib/libtdsodbc.so UsageCount = 1

My odbc.ini file

[SERVER]
Driver = FreeTDS
Description = ODBC connection via FreeTDS
ServerName = SERVER

My freetds.conf file

# A typical Microsoft server
[SERVER]
host = xxx.xxx.xxx.xxx
port = 1433
tds version = 7.2

my perl file

$ perl DB_Test.pl


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


Error


DBI
connect('DRIVER={FreeTDS};Server=xxx.xxx.xxx.xxx;database=xxxxx;','xxxxxx',...)
failed: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
(SQL-08001) at DB_Test.pl line 14

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



when i try to connect using osql i am getting this error

$ sudo TDSVER=7.2 osql -S SERVER -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
[SERVER] not found in /home/perlzuser/.odbc.ini
    reading /usr/local/etc/odbc.ini
[SERVER] found in /usr/local/etc/odbc.ini
found this section:
    [SERVER]
    Driver = FreeTDS
    Description = ODBC connection via FreeTDS
    ServerName = SERVER

looking for driver for DSN [SERVER] in /usr/local/etc/odbc.ini
  found driver line: "    Driver = FreeTDS"
  driver "FreeTDS" found for [SERVER] in odbc.ini
found driver named "FreeTDS"
"FreeTDS" is not an executable file
looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini
  found driver line: "    Driver = /usr/local/freetds/lib/libtdsodbc.so"
  found driver /usr/local/freetds/lib/libtdsodbc.so for [FreeTDS] in
odbcinst.ini
/usr/local/freetds/lib/libtdsodbc.so is an executable file
Using ODBC-Combined strategy
DSN [SERVER] has servername "" (from /usr/local/etc/odbc.ini)

Please I need help to connect MSSQL Server from my perl program using
FreeTDS
and DBD::ODBC


Thanks
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.