Hello Michael and DBI list,
I have DBI installed on site and have been a little perplexed over issues
of what environment vars needed to be set and how that affects our DBI
connections. I recently discovered how the connectivity is behaving. The
database server is 11.9.2 and would use a SYBASE variable that points to
/sybase which would be a local installation of the 11.9.2 libraries. A
client machine would use a net mounted /sybase, where there are an older set
of libraries, 11.0.1.
If a DBI connection being run locally on the database server does not have
LD_LIBRARY_PATH set, or has LD_LIBRARY_PATH set to /sybase (the 11.9.2
version) connections work. If a client box does not have LD_LIBRARY_PATH
set, or has LD_LIBRARY_PATH set to /sybase (which would be 11.0.1 libs). It
cannot make connections. Which leads me to believe that DBD::Sybase is
searching LD_LIBRARY_PATH first and then a default of /sybase if not set
(true?).
We run Sun/Solaris (most versions are 5.7). I compiled DBD::Sybase using
the Sybase Open Client libraries.
So, my two questions are: 1) Why won't 11.0.1 libs work? and 2) Is the
Sybase Open Client lib package even necessary for the compile if connections
can be made using the standard 11.9.2 libraries?
Tim Harsch
Lawrence Livermore National Laboratory
IMAGE Consortium
7000 East Ave., L-448
Livermore, CA 94550
[EMAIL PROTECTED]
(925) 423-1135
