|
Hi,
I have been facing some problems after installing DBD::Oracle 1.24 from here.
Here follows some indications that it got installed properly:
$ perl -MCPAN -e shell
cpan shell -- CPAN exploration and modules installation (v1.9402)
Enter 'h' for help.
cpan[1]> install DBD::Oracle
CPAN: Storable loaded ok (v2.18)
Going to read '/home/prdas/.cpan/Metadata'
Database was generated on Mon, 16 Aug 2010 08:41:36 GMT
CPAN: YAML loaded ok (v0.66)
Going to read 1 yaml file from /home/prdas/.cpan/build/
CPAN: Time::HiRes loaded ok (v1.9715)
DONE
Restored the state of none (in 0.3728 secs)
DBD::Oracle is up to date (1.24).
cpan[2]>
I am using Windows and Cygwin on top of that. The oci.dll and ociw32.dll are in path:
$ which oci.dll
/cygdrive/e/oracle/product/10.2.0/db_1/BIN/oci.dll
$ which ociw32.dll
/cygdrive/e/oracle/product/10.2.0/db_1/BIN/ociw32.dll
So is the Oracle.dll:
$ which Oracle.dll
/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBD/Oracle/Oracle.dll
Even then, when I try to do the following, I am getting the error below:
use DBI;
$db = "TECHNODB";
$username = "distan";
$passwd = "******";
my $dbh = DBI->connect( "dbi:Oracle:$db", $username, $passwd );
Error that comes:
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBD/Oracl
+e/Oracle.dll' for module DBD::Oracle: No such file or directory at /usr/lib/perl5/5.10/i686-cygwin
+/DynaLoader.pm line 201.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /cygdrive/f/E_WSPACE_EURO/DBTestPERL/DBScript.pl line 10
It would be great if someone can guide me to resolve this problem.
Thanks,
PD. |