hello,
can anyone help me identify if I am missing anything... I get the below error on
trying to execute a script that tries to connect to a sybase database..
install_driver(Sybase) failed: Can't load
'/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/site_perl/5.00551/sun4-solaris/auto/DBD/Sybase/Sybase.so'
for module DBD::Sybase: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/site_perl/5.00551/sun4-solaris/auto/DBD/Sybase/Sybase.so:
symbol PL_no_modify: referenced symbol not found at
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/5.00551/sun4-solaris/DynaLoader.pm
line 168.
script:
##########################################################
#!/usr/local/bin/perl
use DBI;
my $dbh = DBI->connect("dbi:Sybase:database=eurekha; server=dev1","eurek","eurek")
|| die "Sybase DB connect error: $DBI::errstr";
$state = "select count(*) from user";
my $sth = $dbh->prepare($state);
$sth->execute();
print "Count \n";
while ((my @row) = $sth -> fetchrow_array)
{
$o_uid=$row[0];
print $o_uid . "\n";
}
$sth->finish();
$dbh->disconnect();
##########################################################
I've tried the following different combinations of LD_LIBRARY_PATH, but it does not
seem to help!
LD_LIBRARY_PATH=$SYBASE/lib
LD_LIBRARY_PATH=$SYBASE/lib:/lib:/usr/lib
would I need to have any other specific directories included into LD_LIBRARY_PATH
other than the above?
output of perl -V
##########################################################
Summary of my perl5 (5.0 patchlevel 5 subversion 51) configuration:
Platform:
osname=solaris, osvers=2.5.1, archname=sun4-solaris
uname='sunos ptsdev3.wks.uk.deuba.com 5.5.1 generic_103640-24 sun4u sparc
sunw,ultra-60 '
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef useperlio=undef d_sfio=undef
Compiler:
cc='/opt/SUNWspro/bin/cc', optimize='-O', gccversion=
cppflags=''
ccflags =''
stdchar='unsigned char', d_stdstdio=define, usevfork=true
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
alignbytes=8, usemymalloc=y, prototype=define
Linker and Libraries:
ld='/opt/SUNWspro/bin/cc', ldflags =''
libpth=/lib /usr/lib /usr/ccs/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -R
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/5.00551/sun4-solaris/CORE'
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Built under solaris
Compiled at Feb 1 1999 18:17:29
@INC:
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/5.00551/sun4-solaris
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/5.00551
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/site_perl/5.00551/sun4-solaris
/db/dev/CPAN/perl/5.005_51/install/SunOS_5.5.1//lib/site_perl/5.00551
##########################################################
.
thanks a lot for your help!
Thanks & Regards,
Hemant Kotta
Execution Services IT
Deutsche Bank, London
+44 (0) 20 754 72931
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
