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:
Expand|Select|Wrap|Line Numbers
- 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
Expand|Select|Wrap|Line Numbers
- 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:RAMDB";
- my $dbh = DBI->connect($DB_DSN, $DB_Username, $DB_Password) || die ("can't connect to DB \n");