472,981 Members | 1,451 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,981 software developers and data experts.

Connecting with Perl to Oracle

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:
Expand|Select|Wrap|Line Numbers
  1. INCLUDE=C:\Program Files\Microsoft Visual Studio 8\VC\INCLUDE;;C:\Program Files\Microsoft Platform SDK for Windows Server 2003 R2\Include
  2. LIB=C:\Program Files\Microsoft Visual Studio 8\VC\LIB;C:\Program Files\Microsoft
  3.  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
  4. LIBPATH=C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
  5. 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:

Expand|Select|Wrap|Line Numbers
  1. use DBI qw(:sql_types);
  2.  use DBD::Oracle;
  4.  my $DB_Username     = "xxxx";
  5.  my $DB_Password     = "xxxxx";
  6.  my $DB_Type         = "";
  7.  my $DB_Handle       = "";
  8.  my $DB_Host         = "";
  9.  my $DB_Sid          = "DBSID";
  10.  my $DB_DSN          = "DBI:Oracle:RAMDB";
  12.   my $dbh = DBI->connect($DB_DSN, $DB_Username, $DB_Password) || die ("can't connect to DB \n");
Does anyone has a suggestion as to how to debug it , or fix it ?
Feb 27 '08 #1
1 2704
971 Expert 512MB
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.

Feb 27 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Keith | last post by:
All: What is the difference between Perl (CGI) and PHP (Apache module)? I thought both used servers to direct the user to the appropiate Perl or PHP program in order to execute the program to...
by: Kong Li | last post by:
Follow up to this thread, the latest Oracle 9i release 2 patchset ( fixed the handle count leak problem. The problem is in Oracle client component. Thanks. Kong ----- From: Kong...
by: Martin_Hurst | last post by:
Is it possible to establish a connection from within a postgres database to another external database on the network, i.e., not a java or scripting connection, BUT by some type of table definition...
by: msnesw.microsoft.com | last post by:
I developed a web application about a year ago that connects to the Oracle DB using MS ODBC for Oracle. But I had to move the whole application to a brand-new PC . When I try to run I get the...
by: rcc.gamer | last post by:
Hello All, I am trying to connect a GridView to an Oracle table using the standard SqlDataSource. The process is fairly simple and there are detailed instructions from Microsoft ......
by: billb | last post by:
I installed a perl extension for PHP to use some perl inside my php primarily because I have perl working with oracle and not php and oracle. So I want to use my old perl scripts, and use the...
by: hakiran | last post by:
Hello all, I have been using Perl DBI the last 6months or so. I use it extensively with MySQL. But recently i tried to access Oracle DB with it and was having trouble. Any help would be...
by: andrewkl | last post by:
hi, I have the following Perl code that inserts a string to an Oracle DB via a stored procedure: #!/usr/local/bin/perl ## Perl v5.8.6 built for sun4-solaris use strict; BEGIN...
by: kanishka1213 | last post by:
when i run perl script in the cmd prompt , it runs well and outputs results from db. but when i run the same script on apache server internet explorer. i get an error as -----...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.