Skip to Content.
Sympa Menu

freetds - [freetds] MSSQL weird problem connectivity

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page