Hi ALL, I get pretty much all the time this error 
message when I try to connect to a remote MS SQL 
Server 2000 database.
Anyone knows why this is happening and how to overcome 
it?
Code looks like this
#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect
("dbi:Sybase:mssql", 'test', 'test');
die "Unable for connect to server $DBI::errstr"
    unless $dbh;
my $rc;
my $sth;
$sth = $dbh->prepare("select * from test");
if($sth->execute) {
    while(@dat = $sth->fetchrow) {
                print "@dat\n";
    }
}

DBI->connect(mssql) failed: OpenClient message: LAYER 
= (1) ORIGIN = (2) SEVERITY = (6) NUMBER = (151)
Message String: ct_connect(): user api layer: internal 
Client Library error: A connection to the server must 
exist on the
connection structure before this routine can be called.
at ./test.pl line 5
Unable for connect to server OpenClient message: LAYER 
= (1) ORIGIN = (2) SEVERITY = (6) NUMBER = (151)
Message String: ct_connect(): user api layer: internal 
Client Library error: A connection to the server must 
exist on the
connection structure before this routine can be called.

Thanks.

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to