DBD-Oracle 1.17 gives "install_driver(Oracle) failed"

I was using Perl 5.6.x (ActiveState Windows port) to connect to Oracle
9i. The modules used then were DBI 1.48 and DBD-Oracle 1.16. I have now
upgraded to Perl 5.8.8 with DBI 1.50 and DBD-Oracle 1.17. The upgrade
was necessitated by the WWW::Babelfish module. Now while I'm able to use
Babelfish properly, my Perl scripts are not able to connect to the
Oracle database. The message send to the browser is as follows:


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 230.
at (eval 19) line 3
Compilation failed in require at (eval 19) line 3.
Perhaps a required shared library or dll isn't installed where expected
at C:/Program Files/Apache Group/Apache2/cgi-bin/iLCLP/iLP_Lgn.pl line 270


While this is a frequent problem as seen by Google results, solutions
are rare. Any hints would be welcome.

TIA.
--
Rohit V. Bhute
http://blog.rvbhute.org

Re: DBD-Oracle 1.17 gives "install_driver(Oracle) failed"

You will have to update DBI and DBD::Oracle from ActiveState. The only
problem I see is the version of DBD::Oracle 1.17 will only work for a
limited numer of Oracle clients ( Instantclient 10.2.0.1 and I think 10XE.)
and windos OSes.

You will have to download that client from Oracle and use it or you will
have to follow the instrunctions in the README.win32.txt
http://svn.perl.org/modules/dbd-oracle/trunk/README.win32.tx t to compile it
yourselft. I suggest you use the latest trunk version of the code

and you can get it here

http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.18 -RC3.zip

as we are close to releaseing a new version of DBD::Oracle

Cheers
John Scoles

----- Original Message -----
From: "Rohit V Bhute"
To:
Sent: Tuesday, July 18, 2006 12:39 PM
Subject: DBD-Oracle 1.17 gives "install_driver(Oracle) failed"


>I was using Perl 5.6.x (ActiveState Windows port) to connect to Oracle 9i.
>The modules used then were DBI 1.48 and DBD-Oracle 1.16. I have now
>upgraded to Perl 5.8.8 with DBI 1.50 and DBD-Oracle 1.17. The upgrade was
>necessitated by the WWW::Babelfish module. Now while I'm able to use
>Babelfish properly, my Perl scripts are not able to connect to the Oracle
>database. The message send to the browser is as follows:
>
>
> 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 230.
> at (eval 19) line 3
> Compilation failed in require at (eval 19) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at C:/Program Files/Apache Group/Apache2/cgi-bin/iLCLP/iLP_Lgn.pl line
> 270
>
>
> While this is a frequent problem as seen by Google results, solutions are
> rare. Any hints would be welcome.
>
> TIA.
> --
> Rohit V. Bhute
> http://blog.rvbhute.org
>

Re: DBD-Oracle 1.17 gives "install_driver(Oracle) failed"

"Can't load Oracle.dll" is often a symptom for a missing OCIW32.DLL.
Oracle.dll loads OCIW32.DLL at startup, if that fails, loading
Oracle.DLL fails, hence the error message.

OCIW32.DLL is provided by the Oracle client software, newer Versions of
Oracle install this DLL only(?) when you choose to install the Oracle
ODBC drivers. The directory containing OCIW32.DLL must be listed in the
PATH environment variable.

Unfortunately, some third party software comes with a very ancient
version of OCIW32.DLL, often installed into the windows\system32 or
windows\system directory. Rename or remove that DLL.

Alexander

On 18.07.2006 18:39, Rohit V Bhute wrote:

> I was using Perl 5.6.x (ActiveState Windows port) to connect to Oracle
> 9i. The modules used then were DBI 1.48 and DBD-Oracle 1.16. I have
> now upgraded to Perl 5.8.8 with DBI 1.50 and DBD-Oracle 1.17. The
> upgrade was necessitated by the WWW::Babelfish module. Now while I'm
> able to use Babelfish properly, my Perl scripts are not able to
> connect to the Oracle database. The message send to the browser is as
> follows:
>
>
> 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 230.
> at (eval 19) line 3
> Compilation failed in require at (eval 19) line 3.
> Perhaps a required shared library or dll isn't installed where expected
> at C:/Program Files/Apache Group/Apache2/cgi-bin/iLCLP/iLP_Lgn.pl
> line 270
>
>
> While this is a frequent problem as seen by Google results, solutions
> are rare. Any hints would be welcome.
>
> TIA.



--
Alexander Foken
mailto:alexander@foken.de http://www.foken.de/alexander/