issue with DBI and MS SQL SERVER

[DanBev]

Hi monks, I've an issue connecting to MS SQL Server with DBI. I've read all tutorials and configurations of TDS but my code still not works...

Simply I try my $dbh = DBI->connect(DBI:Sybase:server=xx.xx.xx.xx, "USERNAME", "PASSWORD") ; and the error is

DBI connect('server=xx.xx.xx.xx','USERNAME',...) failed: OpenClient me
+ssage: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (41)
Server xx.xx.xx.xx, database
Message String: Unable to connect: Adaptive Server is unavailable or d
+oes not exist
 at check_ultima_chiamata.pl line 19
Cant' connect to database: OpenClient message: LAYER = (0) ORIGIN = (0
+) SEVERITY = (78) NUMBER = (41)
Server xx.xx.xx.xx, database
Message String: Unable to connect: Adaptive Server is unavailable or d
+oes not exist

My TDS configuration is

[xx.xx.xx.xx]
host = xx.xx.xx.xx
port = 1433
tds versione = 7.0

Instead, trying in shell it works

root@___# /usr/local/freetds/bin/tsql -S xx.xx.xx.xxx -U USER
Password:
locale is "it_IT.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1>

Please help me to understand...

[blue_cowdawg]

It's been a really long time since I used the Sybase DBD driver but I seem to remember that you need to create an entry in an interfaces file to map between a logical server name and the physical server name. Not sure what you mean by "TDS configuration."

If I remember how the interfaces file is configured correctly it looks something like:

[BILLING] 
host = 123.213.13.2
port = 1433
database = BILLING
user = USER
password = PASSWORD

Then you use the handle BILLING to connect with. Also if memory serves me correctly you have supply the path to the Sybase libraries

BEGIN{  $ENV{SYBASE}='/opt/sybase....handwaving here...';
}
use DBI;
my $dbh=DBI->connect('DBI:Sybase:server=BILLING') or die $DBI->errstr;

Hope this helps..

[DanBev]

blame on me! I'm configuring a freetds.conf file in /usr/local/freetds/etc/, but the script use the freetds.conf file in /usr/local/etc, due to a re-installation of libraries and various attempt to resolve my problem. Is not a beautiful presentation my first post here... :) Thank you for the reply!

[GotToBTru]

Perhaps Re: connect string for sybase might be of help here? Super Search is an excellent resource.

[DanBev]

Thank you for the reply. I've resolved my issue simply because I was working on wrong freetds.conf file

[Anonymous Monk]

Could you add another comment that explains the whole issue a bit more clearly, now that you completely understand it and have solved it? Writing for the next poor schleb who is banging their head against this ... and so that the rest of us know more about this slightly-arcane setup?

[GotToBTru]

Deleted useless comment -- I'm not familiar with Sybase or SQL Server and it shows.