Thanks for the 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
________________________________
From: Alexander Foken <alexan...@foken.de>
To: Tony Byorick <t...@byorick.com>; "dbi-users@perl.org" <dbi-users@perl.org>
Sent: Monday, January 27, 2014 11:04 AM
Subject: Re: Getting Error Message "Can't load
'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle
On 26.01.2014 01:19, Tony Byorick wrote:
I am trying to configure an Oracle connection from Perl running on a Windows 7
desktop to an Oracle 11g database running on Linux; however the database
connection step is failing.
The following line of perl code fails:
use DBD::Oracle;
Below is the full error message:
Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:%1 is not a valid Win32 application at C:/Perl64/lib/DynaLoader.pm
line 191. at C:\go\perl\tracker\pingOracle.pl line 17.
[...]
I'm running 64 bit Windows and 64 bit Perl. Is it possible the DBD loader is
failing because it is trying to load a 32 bit version of the Oracle driver?
Yes. The "bitness" of Perl and the database libraries must match,
not only for Oracle, but for every database (and every C/C++ library
you want to use from Perl).
[...]
>
>
>
Try to get a 64 bit Oracle client, or use a 32 bit Perl.
Alexander
--
Alexander Foken mailto:alexan...@foken.de http://www.foken.de/alexander/
