Re^5: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...

~~Install msys, mingw, and nmake, and compile/install it yourself from source.~~

Does your PATH include the directory where OCI.dll is? On Windows, I do not have any ORA_HOME or ORACLE_HOME or LD_LIBRARY_PATH set (though TNS_ADMIN is set), but PATH includes the directory where OCI.dll is, and the default DBD::Oracle that came w/ActiveState works fine.

Comment on Re^5: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...

Replies are listed 'Best First'.
Re^6: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8... by Anonymous Monk on Aug 29, 2008 at 13:44 UTC
Ok, I finally found my error on this! Thanks to all who tried to help. I was requiring a file at the top of my code that had the following statement in it $ENV{"PATH"} = "";. This was effectively wiping out all my path information before I attempted to create a connection to the Oracle database. Strangely this exact same code works fine on a Linux OS. It seems the PATH environment variable is not as important there when trying to make a connection. I don't understand why. It seems like it should fail on both OS's but it doesn't. Thanks again for the help...	[reply]
Re^7: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8... by Corion (Patriarch) on Aug 29, 2008 at 14:03 UTC
Windows uses `$ENV{PATH}` for locating libraries while other systems use other environment variables, for example `$ENV{LD_LIBRARY_PATH}`.	[reply] [d/l] [select]