Skip to Content.
Sympa Menu

freetds - Re: [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: Igor Korot <ikorot01 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
  • Date: Fri, 14 Dec 2012 00:30:24 -0800

Hi,
Google is your friend.
The log you posted is clear enough.

Thank you.

On Thu, Dec 13, 2012 at 5:04 AM, Sankar G <geoinnovate AT gmail.com> wrote:
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page