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

2006-07-19 Thread Alexander Foken
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/



DBD-Oracle 1.17 gives install_driver(Oracle) failed

2006-07-18 Thread Rohit V Bhute
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.
--
Rohit V. Bhute
http://blog.rvbhute.org


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

2006-07-18 Thread John Scoles
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.txt 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 [EMAIL PROTECTED]

To: dbi-users@perl.org
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:


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.
--
Rohit V. Bhute
http://blog.rvbhute.org