in reply to Re: Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle
in thread Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle

Thanks for the many thoughtful responses to my question.

I have not found a root cause for the problem however, I have found a workaround by installing the 32 bit version of ActiveState Perl and using it rather than the 64 bit version.

With 32 bit Perl, "$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid;port=$port", $user, $passwd);" performs without complaining and then executes SQL and returns the answer set.

-Tony

  • Comment on Re^2: Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle
  • Download Code

Replies are listed 'Best First'.
Re^3: Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle
by syphilis (Archbishop) on Jan 28, 2014 at 02:15 UTC
    I have found a workaround by installing the 32 bit version of ActiveState Perl and using it rather than the 64 bit version

    This is further indication that the oracle dll that Perl/lib/auto/DBD/Oracle/Oracle.dll tries to load is 32-bit (as already suggested by others) and therefore can't be loaded by a 64-bit perl.

    Cheers,
    Rob