> 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/DBD-Oracle.ppd
> <ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.3/DBD-Oracle.ppd>
>
> ... appeared to work properly. But when I ...
>
> 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]
>
>
