>
>
> > Hello, I'm attempting to access Oracle databases on a remote server
> > through a Perl 5.8.3 script with Apache 2 on a Windows XP. Any
> > insights would be greatly appreciated. Installation via ...
> >
> > ppm install
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DB> D-Oracle.ppd
> >
>
<ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd>
>
> ... appeared to work properly. But when I ...
See if you find Oracle.dll at that location. Chances are, it's looking for
a file that's not in your path (i.e. the OCI dlls). Is the apache server
running as "you" or some other user as a service? If so, make sure that
user's path has the Oracle binaries in it.
Jeff
>
> use DBI;
> $dbh = DBI ->connect('dbi:Oracle:bank.canso3','fowler','blank',
> {RaiseError>1,AutoCommit=>1});
>
> ... the server log reports:
>
> [Fri Jun 25 08:42:52 2004] [error] [client 142.2.70.49]
> install_driver(Oracle) failed: Can't load
> 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
> load_file:The specified module could not be found at
> C:/Perl/lib/DynaLoader.pm line 229., referer:
> http://mar6031903/cgi-bin/buildAnalysisPage.cgi
> <http://mar6031903/cgi-bin/buildAnalysisPage.cgi>
>
> I have no problem accessing the databases using SqlPlus 8, or via ODBC
> in some packages I use (whether user or system DSNs). However, the
> SqlPlus application must be active for other applications to connect
> with ODBC. And maybe relevant that a previous attempt to install the
> default version of DBD::Oracle aborted with the message "The
> ORACLE_HOME environment variable value (V:/ORAWIN6I) is not valid".
>
>
> Mark Fowler
> Marine Fish Division
> Bedford Inst of Oceanography
> Dept Fisheries & Oceans
> Dartmouth NS Canada
> [EMAIL PROTECTED]
>
>
