Re: issue with DBI and MS SQL SERVER

[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!