Any ideas to track down why solaris 8 code (which runs
on other solaris host) fails database connect
from browser but runs from command line OK ? Code
is below.
Thank you.
----------------- error file---------------------------------
install_driver(Oracle) failed: Can't load
'/usr/local/ActivePerl-5.6/lib/site_perl/5.6.1/sun4-solaris-thread-multi/auto/DBD/Ora
cle/Oracle.so' for module DBD::Oracle: ld.so.1: /usr/local/ActivePerl-5.6/bin/perl:
fatal: /export/home/oracle/ora3/lib/libclnt
sh.so.8.0: Permission denied at
/usr/local/ActivePerl-5.6/lib/5.6.1/sun4-solaris-thread-multi/DynaLoader.pm line 206.
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
~
----------------------------------------------------------
-------------- test code ---------------------------------
#!/usr/local/ActivePerl-5.6/bin/perl -w
print "Content-type: text/html\r\n\r\n";
use DBI;
use CGI qw/:standard/;
BEGIN{
$ENV{ORACLE_HOME}='/export/home/oracle/ora3';
$ENV{ORACLE_SID}= ora3;
}
open (STDERR, ">testconnect_error.txt");
%attr = (
PrintError => 0,
RaiseError => 1
);
#-----------------------------------
print "t1\n";
print "t1\n";
my $dbh = DBI->connect ('DBI:Oracle:server1','scott','tiger',\%attr) or die "Couldnt
connect" . DBI-> errstr;
print "t2\n";
print "t2\n";
#-----------------------------------
