Re: connecting to DBI::Oracle from web pages

Try creating a symbolic link /usr/lib/libclntsh.so.1.0 pointing to the real libclntsh.so.1.0 which should be under $ORACLE_HOME/lib. Or copy that file over into /usr/lib.

Otherwise, your Web page should call a shell script that setenv LD_LIBRARY_PATH [whatever your ORACLE_HOME is really is]/lib, followed by your perl script.

Yong Huang

<kehleyr678_at_my-deja.com> wrote in message news:8lmrps$jii$1_at_nnrp1.deja.com...
> Hello,
>
> I have an Oracle 8 Enterprise server and an Apache Web serevr running or
> Red hat Linux. I have a script which connects to the database through
> DBI and performs a select. From the command line this works perfectly,
> but from the Web page it does not. It stops right after the
> $dbh->connect statement.
>
> I have cheched the logs and there is some strange message saying:
>
> "install_driver(Oracle) failed: Can't load
> '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/Oracle/Oracle.so'
> for module DBD::Oracle: libclntsh.so.1.0: cannot open shared object
> file: No such file or directory at
> /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169, <CONFIG> chunk
> 3.
>
> at (eval 1) line 3
> Perhaps a required shared library or dll isn't installed where expected
> "
>
> I have no Dynaloader.pm file, and neither do I have a i386-linux flder
> under 5.00503.
>
> What should I do?? Thnx!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 26 2000 - 00:00:00 CDT