Oscar, Is Oracle installed? If so, what the permissions on $ORACLE_HOME/lib and $ORACLE_HOME/libclntsh.so.8.0?
-----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 11:45 PM To: dbi-users@perl.org Cc: [EMAIL PROTECTED] Subject: (Fwd) dbd-oracle-1.16 ----- Forwarded message from Oscar Gomez <[EMAIL PROTECTED]> ----- X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no PTR record, or PTR and A records do not match From: Oscar Gomez <[EMAIL PROTECTED]> To: Tim Bunce <[EMAIL PROTECTED]> Subject: dbd-oracle-1.16 Date: Wed, 19 Jul 2006 16:54:32 -0500 X-OriginatingIP: 10.0.1.50 (ogomez) Tim I have the following error when execute program in apache-cgi-oracle [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/ Oracle.so' for module DBD::Oracle: libclntsh.so.8.0: 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., referer: http://10.0.0.6/cgi-bin/FGI?py6110 [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] at (eval 1) line 3, referer: http://10.0.0.6/cgi-bin/FGI?py6110 [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation failed in require at (eval 1) line 3., referer: http://10.0.0.6/cgi-bin/FGI?py6110 [Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Perhaps a required shared library or dll isn't installed where expected, referer: http://10.0.0.6/cgi-bin/FGI?py6110 perl version 5.8.5 lunux enterprise ES 4 DBD-Oracle-1.16 DBI-1.30 Thanks -- Open WebMail Project (http://openwebmail.org) ---------- Original Message ----------- From: Tim Bunce <[EMAIL PROTECTED]> To: "Garrett, Philip (MAN-Corporate)" <[EMAIL PROTECTED]> Sent: Wed, 19 Jul 2006 08:37:27 -0700 Subject: Re: DBI->installed_drivers() usage > On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN- > Corporate) wrote: > > Paul Griffin wrote: > > > I'm running Win XP with Perl 5.8.8. > > > > > > If I try and run the following code : > > > > > > use DBI; > > > my %drivers = DBI->installed_drivers(); > > > foreach (keys( %drivers)) { > > > print "$_ uses $drivers{$_}\n"; > > > } > > > > > > Nothing is returned. Yet if I use : > > > > > > my @drivers = DBI->available_drivers(); > > > > > > I get a list of drivers that I can then access with : > > > > > > @dataSources = DBI->data_sources($_); > > > > > > Am I using DBI->installed_drivers() incorrectly? > > > > DBI->installed_drivers returns only the drivers that are actually loaded > > into the current process. Installed in this case means "installed into > > memory." > > Ah. The docs weren't clear: > > --- DBI.pm (revision 6618) > +++ DBI.pm (working copy) > @@ -2753,10 +2753,15 @@ > > %drivers = DBI->installed_drivers(); > > -Returns a list of driver name and driver handle pairs for all > -installed drivers. The driver name does not include the 'DBD::' > -prefix. Added in DBI 1.49. > +Returns a list of driver name and driver handle pairs for all > drivers +'installed' (loaded) into the current process. The driver > name does not +include the 'DBD::' prefix. > > +To get a list of all drivers available in your perl instalation you > can use +L</available_drivers>. + +Added in DBI 1.49. + =item C<installed_versions> > > DBI->installed_versions; > > Tim. ------- End of Original Message ------- ----- End forwarded message ----- This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.