Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sankar G <geoinnovate AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
  • Date: Thu, 13 Dec 2012 18:34:49 +0530

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




Archive powered by MHonArc 2.6.24.

Top of Page