freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Franck Y" <franck110 AT gmail.com>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] MSSQL weird problem connectivity
- Date: Tue, 6 Jan 2009 18:24:01 -0500
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
-
[freetds] MSSQL weird problem connectivity,
Franck Y, 01/06/2009
- Re: [freetds] MSSQL weird problem connectivity, James K. Lowden, 01/06/2009
Archive powered by MHonArc 2.6.24.