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

See also http://www.freetds.org/userguide/odbcconnattr.htm


2012/12/14 Sankar G <[email protected]>:
> 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
>>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds