"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:

<cut>
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
</cut>

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

TIA.



--
Alexander Foken
mailto:[EMAIL PROTECTED]  http://www.foken.de/alexander/

Reply via email to