DBD-Oracle/Perl 5.8.3/Apache2/Windows XP
From: Mark Fowler (FowlerM_at_mar.dfo-mpo.gc.ca)
Date: 06/29/04
- Previous message: Nayana Hanji: "Changing driver from OCI8 to OCI7 driver for DBI"
- Next in thread: Jeff Urlwin: "RE: DBD-Oracle/Perl 5.8.3/Apache2/Windows XP"
- Reply: Jeff Urlwin: "RE: DBD-Oracle/Perl 5.8.3/Apache2/Windows XP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Jun 2004 07:13:58 -0300 To: "DBI (dbi-users@perl.org)" <dbi-users@perl.org>
> 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
> fowlerm@mar.dfo-mpo.gc.ca
>
>
- Previous message: Nayana Hanji: "Changing driver from OCI8 to OCI7 driver for DBI"
- Next in thread: Jeff Urlwin: "RE: DBD-Oracle/Perl 5.8.3/Apache2/Windows XP"
- Reply: Jeff Urlwin: "RE: DBD-Oracle/Perl 5.8.3/Apache2/Windows XP"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
