For Programmers: Free Programming Magazines  


Home > Archive > PERL Miscellaneous > July 2006 > Sybase connection error









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Sybase connection error
lnatz

2006-07-28, 7:59 am

Hi I am having a problem with this line of code:
$DBH =
DBI->connect("dbi:Sybase:server=$dbserver", $dbuser, $dbpassword)
|| die "$DBI::errstr";
$DBH->do("use $database");

I am getting this error when executing:
DBI connect('server=NYT_LIBRAONLINE','natrab
i
',...) failed: Server message number=4002 severity=14 state=1 line=0
server=NYTINV3T002 text=Login failed.
OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER =
(44)
Server NYT_LIBRAONLINE, database
Message String: ct_connect(): protocol specific layer: external error:
The attempt to connect to the server failed.
at ./purge.pl line 45
Server message number=4002 severity=14 state=1 line=0
server=NYTINV3T002 text=Login failed.
OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER =
(44)
Server NYT_LIBRAONLINE, database
Message String: ct_connect(): protocol specific layer: external error:
The attempt to connect to the server failed.


Basically I am trying to connect to Sybase and I can't figure out what
I am missing.

DJ Stunks

2006-07-28, 6:59 pm

lnatz wrote:
> Hi I am having a problem with this line of code:
> $DBH =
> DBI->connect("dbi:Sybase:server=$dbserver", $dbuser, $dbpassword)
> || die "$DBI::errstr";
> $DBH->do("use $database");
>
> I am getting this error when executing:
> DBI connect('server=NYT_LIBRAONLINE','natrab
i
> ',...) failed: Server message number=4002 severity=14 state=1 line=0
> server=NYTINV3T002 text=Login failed.
> OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER =
> (44)
> Server NYT_LIBRAONLINE, database
> Message String: ct_connect(): protocol specific layer: external error:
> The attempt to connect to the server failed.
> at ./purge.pl line 45
> Server message number=4002 severity=14 state=1 line=0
> server=NYTINV3T002 text=Login failed.
> OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER =
> (44)
> Server NYT_LIBRAONLINE, database
> Message String: ct_connect(): protocol specific layer: external error:
> The attempt to connect to the server failed.
>
>
> Basically I am trying to connect to Sybase and I can't figure out what
> I am missing.


I would say this is an authentication problem:

http://manuals.sybase.com/onlineboo...9367;pt=39281/*

-jp

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com