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

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 <[email protected]> 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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds