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: Sankar G <geoinnovate AT gmail.com>
  • To: 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 17:40:25 +0530

Hi

I Googled a lot for this,But didn't get any solution.
I am using ubuntu 12.04 LTS
Sql server 2008 (on my Remote machine)
freetds and unixodbc latest version

I have configured correctly as per the user-guide, But still getting error.

Please help me to get out of this.

Thanks

Igor Korot <ikorot01 <at> gmail.com> writes: > > 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