Connecting with Perl to Oracle

[megaman1]

I’m trying to connect with perl DBD::Oracle on Windows to Oracle DB (Linux).

I compiled the Oracle.dll using the commands “perl Makefile.pl” “nmake” and “nmake install”, but when I try to connect to the DB, I get the following runtime error:

“R6034 an application has made an attempt to load the C Runtime library incorrectly.
Please contact the applications’ support team for more information.”

I suspect that I mixed the versions of VC compiler/Linker, when creating the Oracle.dll.

Here are the important env variables:

INCLUDE=C:\Program Files\Microsoft Visual Studio 8\VC\INCLUDE;;C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Include
LIB=C:\Program Files\Microsoft Visual Studio 8\VC\LIB;C:\Program Files\Microsoft
 Visual Studio 8\SDK\v2.0\lib;;C:\Program Files\Microsoft Visual Studio 8\VC\LIB;C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Lib
LIBPATH=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
Path=C:\Program Files\Microsoft Visual Studio 8\Common7\IDE;C:\Program Files\Microsoft Visual Studio 8\VC\BIN;C:\Program Files\Microsoft Visual Studio 8\Common7\Tools;C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\bin;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727;C:\Program Files\Microsoft Visual Studio 8\VC\VCPackages;C:\Perl\bin\;C:\Perl\bin\;C:\Perl\site\bin;C:\Perl\bin;c:\Perl_ActiveState\site\bin;c:\Perl_ActiveState\bin;D:\oracle\product\10.2.0\client_1\bin;C:\Oracle9i\bin;C:\Orant\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\TELSTRA\Utils;c:\Program Files\Rational\common;C:\Program Files\IBM\Installation Manager\eclipse\lib;C:\Program Files\OpenVPN\bin

here is my code:

[CODE=perl]use DBI qw(:sql_types);
use DBD::Oracle;

my $DB_Username = "xxxx";
my $DB_Password = "xxxxx";
my $DB_Type = "";
my $DB_Handle = "";
my $DB_Host = "1.2.3.4";
my $DB_Sid = "DBSID";
my $DB_DSN = "DBI:Oracle:RAM DB";

my $dbh = DBI->connect($DB_DS N, $DB_Username, $DB_Password) || die ("can't connect to DB \n");
[/CODE]
Does anyone has a suggestion as to how to debug it , or fix it ?

[eWish]

If you are on a windows machine and using ActiveState, you can use the PPM utility to install the DBD::Oracle module for you. Try that and see if it corrects your problems.


Also, please use Code tags when posting code here. Thank You.

--Kevin