Problem with DBD-Oracle



I am having a problem with connecting to an Oracle DB with DBD-Oracle.
When I run the script I wrote, I get a popup that says "Perl.exe - No
Entry Point Found The Procedure Entry Point PL_memory_wrap could not be
located in the dynamic link library perl58.dll". Then in the cmd
windows, I get this error:

"install_driver(Oracle) failed: Can't load
'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:The specified procedure could not be found at
C:/Perl/lib/DynaLoader.pm line 230. at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where
expected"

I have the following

Perl 5.8.6
DBD-Oracle 1.16
DBI 1.48
Oracle client 8i, however i get the same error with Oracle client 9i.

Windows 2003.

Here is the code.
use DBI;
$oracle_sid = "TRN1";
$oracle_host = "server";
$oracle_user = "user";
$oracle_pass = "pass";
$oracle_port = 1525;

$dbh_oracle =
DBI->connect('dbi:Oracle:host=$oracle_host;sid=$oracle_sid;port=$oracle_port',
'$oracle_user', '$oracle_pass') or die "Can\'t connect to --
$DBI::errstr\n";

I have confirmed port 1525.

Has anyone else been able to fix this?

Thank you
Patrick

.



Relevant Pages

  • Re: Asp.net / iis / oracle problem - never mind , i think i found
    ... Installed Oracle Client software on Server ... My DBA had to create synonyms for the account used to access the database to ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Oracle Client and ADO.NET
    ... I was reading thru some documents and it seems that an oracle client ... installation, Rapid App Dev Installation, etc... ... Of course I can use OLEDB/ODBC providers instead if this doesn't ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Trying to Connect SSIS to Oracle on x64
    ... I'm trying to get SSIS to connect to Oracle on 64-bit, ... The Oracle client can connect to the server and the connection tests ok. ... Reinstalled the full Oracle client x64. ... It's as if the Microsoft drivers don't know Oracle is installed, ...
    (microsoft.public.sqlserver.dts)
  • Re: Trying to Connect SSIS to Oracle on x64
    ... Joseph got his package to run. ... I'm trying to get SSIS to connect to Oracle on 64-bit, ... The Oracle client can connect to the server and the connection tests ... String on Microsoft's ODBC drivers. ...
    (microsoft.public.sqlserver.dts)
  • Asp.net / iis / oracle problem
    ... box does not think that the Oracle Client is not installed... ... Oracle client and networking components were not found. ... later client software installation. ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.dotnet.framework.aspnet)