FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Kirk wrote:
> 
> I can't connect using DBD::Sybase
> because the perl script fails to compile. I must point out that I
> searched the archives and I found a thread dealing with the same
> problem and Fedora Core 2 (I'm using FC 3). The fix was to add
> /usr/local/lib to /etc/ld.so.conf. I did it and I still get the same
> error:
> 
> # export LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH
> # perl mssql.pl 
> install_driver(Sybase) failed: Can't load
> '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Sybase
> /Sybase.so' for module DBD::Sybase: libct.so.3: cannot open shared
> object file: No such file or directory at
> /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
>   at (eval 1) line 3
> Compilation failed in require at (eval 1) line 3.
> Perhaps a required shared library or dll isn't installed where expected
>   at mssql.pl line 5
> 
> I do have libct.so..
> ls /usr/local/freetds/lib
                ^^^^^^^
> libct.a     libct.so.3.0.0 

You already got some good advice.  My only observation is that if you're
going to use LD_LIBRARY_PATH to help your run-time linker find libct, you
have to give it the right path!  You added /usr/local/lib, but the library
is in /usr/local/freetds/lib.  

The right way to do this, as with all rt linker problems, is to add the
RPATH to the binary.  (I answered a similar question at length recently;
see the archives for "sqsh won't run").   I'm not enough of a perlhead to
know exactly how that's done with Perl, but I would add it to the UG if
someone enlightens me.  

HTH.

--jkl