Problem in connecting to sybase.

Nalina has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I have sybase installed on solaris server and I get the following error when I try to connect to sybase through DBI.

Open Client Message:
Message number: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (131)
Message String: ct_init(): network packet layer: internal net library 
+error: Attempt to load protocol driver failed
install_driver(Sybase) failed: DBD::Sybase initialize: ct_init(112) fa
+iled at /prog/perl/curr_inst/lib/5.8.0/sun4-solaris/DynaLoader.pm lin
+e 249, <IN> line 291.
Compilation failed in require at (eval 1) line 3, <IN> line 291.

 at /local/adm/perl/lib/Db.pm line 154
[download]

I found that the SYBASE Environment variable is set. But still it doesn't work. Could anyone plz help me on this?

Comment on Problem in connecting to sybase. Download Code

Replies are listed 'Best First'.
Re: Problem in connecting to sybase. by Anonymous Monk on Mar 31, 2008 at 10:59 UTC
The problem is fixed if you set LD_LIBRARY_PATH = $SYBASE/$SYBASE/lib	[reply]
Re^2: Problem in connecting to sybase. by Nalina (Monk) on Mar 31, 2008 at 11:24 UTC
It is already set in .cshrc	[reply]
Re^3: Problem in connecting to sybase. by derby (Abbot) on Mar 31, 2008 at 13:29 UTC
Nope ... SYBASE and LD_LIBRARY_PATH should be all you need. But that should be LD_LIBRARY_PATH=$SYBASE/lib (not $SYBASE/$SYBASE/lib). You should double check the ENV vars within the script to ensure they are set correctly (just inspecting .cshrc may not be enough) - otherwise, if they are, then I would suspect a bad install. -derby	[reply]
Re^4: Problem in connecting to sybase. by Nalina (Monk) on Apr 01, 2008 at 14:06 UTC
Re^5: Problem in connecting to sybase. by derby (Abbot) on Apr 01, 2008 at 15:02 UTC
Re^2: Problem in connecting to sybase. by Nalina (Monk) on Mar 31, 2008 at 11:47 UTC
Is there any other environment variable is to be set for this to work?	[reply]