Problem with DBD::Oracle

gasho has asked for the wisdom of the Perl Monks concerning the following question:

Dear perl monks, I am getting this error running active perl on WinXP, note my oracle client is working and I can connect to specified data base through sqlplus, I will appreciate your help: install_driver(Oracle) failed: Can't load 'D:/Perl/site/lib/auto/DBD/Oracle/Orac le.dll' for module DBD::Oracle: load_file:The specified procedure could not be f ound at D:/Perl/lib/DynaLoader.pm line 230. at (eval 63) line 3 Compilation failed in require at (eval 63) line 3. Perhaps a required shared library or dll isn't installed where expected

use DBI;

$ENV{ORACLE_HOME} = 'C:\oracle\product\10.2.0\client_1'; #or whatever
$ENV{LD_LIBRARY_PATH} = 'C:\oracle\product\10.2.0\client_1\LIB'; #or w
+hatever
$ENV{LD_RUN_PATH} = 'C:\oracle\product\10.2.0\client_1\LIB'; #or whate
+ver


my $dbh = DBI->connect( 'dbi:Oracle:EAORA10G',
                        'JdoeJd',
                        'Dj111222',
                        {
                          RaiseError => 1,
                          AutoCommit => 0
                        }
                      ) || die "Database connection not made: $DBI::er
+rstr";

my $sql = qq{ SELECT CMID FROM CMOBJECTS};
my $sth = $dbh->prepare( $sql );
$sth->execute();

$dbh->disconnect();
[download]

(: Life is short enjoy it :)

Comment on Problem with DBD::Oracle Download Code

Replies are listed 'Best First'.
Re: Problem with DBD::Oracle by ikegami (Patriarch) on Jun 06, 2007 at 17:34 UTC
Perl can't find the compiled portion of DBD::Oracle. The module is not properly installed. Try again.	[reply]
Re^2: Problem with DBD::Oracle by gasho (Beadle) on Jun 06, 2007 at 17:41 UTC
I tried still the same:( Fetching oraociei10.dll.gz (28 Mb) 28Mb/28Mb (100.00%) Decompressing................................................................... ................................................................................ ........................... oraociei10.dll checksum: OK Successfully installed DBD-Oracle version 1.17 in ActivePerl 5.8.7.815. ppm> (: Life is short enjoy it :)	[reply]
Re: Problem with DBD::Oracle by randyk (Parson) on Jun 06, 2007 at 21:40 UTC
Windows searches the PATH environment variable to look for dlls; try `C:\> set PATH=C:\oracle\product\10.2.0\client_1\LIB;%PATH%` [download] (assuming the dlls are in `C:\oracle\product\10.2.0\client_1\LIB`).	[reply] [d/l]
Re: Problem with DBD::Oracle by derby (Abbot) on Jun 06, 2007 at 18:21 UTC
Setting LD_LIBRARY_PATH (and LD_RUN_PATH) like this does not accomplish what you want. Either set them in the environment and then invoke the script or see (tye)Re: programatically setting the LD_LIBRARY_PATH. -derby	[reply]
Re^2: Problem with DBD::Oracle by Anonymous Monk on Jun 07, 2007 at 06:09 UTC
Setting LD_PATH on win32 doesn't accomplish anything period. LD is for nix.	[reply]


Clear questions and runnable code get the best and fastest answer
	PerlMonks