[freetds] MSSQL weird problem connectivity

Franck Y franck110 at gmail.com
Tue Jan 6 18:24:01 EST 2009


Hello Friends,


I have a really weird behavior !

Here is my freeetds.conf

---------------------
[MS]
   host = 192.168.10.95
   tds version = 8.0
   port= 1093
---------------------
It is an instance but for some reason i cannot make it work with INSTANCE=XXXX

I was able to connect using
-----------------------------------
tsql -S MS -U theuser
----------------------------------
i got the "1>"

After that i used i complied sybase and used a  perl script

------------------------------
#!/usr/bin/perl
use DBI;


my $dbh = DBI->connect("dbi:Sybase:MS","theuser","XXXXX");

die "Unable for connect to server $DBI::errstr"
   unless $dbh;

my $rc;
my $sth;

$sth = $dbh->prepare("select \@\@servername");
if($sth->execute) {
   while(@dat = $sth->fetchrow) {
               print "@dat\n";
   }
}
-------------------------------


 i got this  every times this error message

DBI connect('MS','thesuer',...) failed: (no error string) at
../sample_scripts/init.pl line 5
Unable for connect to server  at ../sample_scripts/init.pl line 7.


Anything idea of what i am missing???

SYBASE=/usr/local/freetds is set btw


Thanks

-- 
Franck


More information about the FreeTDS mailing list