Hi,
I'm having problems opening a db connection to Sybase using dbish. The
perldoc says to use the syntax:
dbi:Sybase:server=X [user [password]]
So, I executed dbish and did the following
Available DBI drivers:
1: dbi:ADO
2: dbi:ExampleP
3: dbi:Oracle
4: dbi:Proxy
5: dbi:Sybase
Enter driver name or number, or full 'dbi:...:...' DSN:
here I entered:
dbi:Sybase:server=SERVER1 user_name passwd
I received the following error:
Connecting to 'dbi:Sybase:server=SERVER1 user_name passwd' as ''...
DBI->connect failed: server message number=4002 severity=14 state=1 line=8
server=SERVER1 text=Login failed.
OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (4) NUMBER = (44)
Message String: ct_connect(): protocol specific layer: external error: The
attempt to connect to the server failed.
at /usr/local/lib/perl5/site_perl/DBI/Shell.pm line 738
My configuration is:
SunOS 5.6
Perl 5.00404
DBI 1.13
Shell 10.6
DBD::Sybase 0.21
Sybase 11.9.2
The server name, user and id are definitely correct since I use them to
open DBI connections in my Perl scripts and connect through isql all of
the time.
I've tried comma-delimiting the dsn, user, password and ';' delimiting the
list as well. All gave pretty much the same error. Would anyone know
what it is I am doing wrong?
Thanks
--Curt
