I installed Active State Perl 5.10 32bit. It includes DBD::Oracle. I have Oracle installed and running on my machine and most of the path variables set correctly I think. Here is the error message I receive when tryingto use DBD:Oracle:
Can't load 'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:%1 is not a valid Win32 application at C:/Perl/lib/DynaLoader.pm line 202.
at \\emc-filer\etl\data\Jamaica\scripts\Modules\test1.pl line 7
Compilation failed in require at \\emc-filer\etl\data\Jamaica\scripts\Modules\test1.pl line 7.
BEGIN failed--compilation aborted at \\emc-filer\etl\data\Jamaica\scripts\Modules\test1.pl line 7.
I included the path to the oci.dll (
C:\oracle\product\10.2.0\client_1\BIN) into my path variables, but that didn't help anything. I also made sure that .dll is in the folder. It is!