CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
DBI::Oracle

 



ms10380
Novice

Mar 12, 2010, 7:57 AM

Post #1 of 2 (6978 views)
DBI::Oracle Can't Post

I have a script that connects to a oracle DB using the following string:

unless ($dbh = DBI->connect ("dbi:Oracle: host=$ORACLE_HOME;sid=$ORACLE_SID;port=$ORACLE_PORT", $ORACLE_USERID, $ORACLE_PASSWORD)) {
print "Failed to login to the database";
$dbh = undef; return 'FAILED';
}

For some reason the script works fine on one machine but when executing on a second machine I receive the following popup error:

The procedure entry point OCIIntervalToText could not be located in the dynamic link library OCI.dll.

And the script command line return the error

install_driver(Oracle) failed: Can't load 'C:/Perl/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 201.
at (eval 8) line 3
Compilation failed in require at (eval 8) line 3.
Perhaps a required shared library or dll isn't installed where expected at C:\oracle.pl line 165


I verified the versions of DBD::Oracle, OCI.dll on both systems and they are identical. Any thoughts as to what else can cause this problem?


Thanks


roolic
User

Mar 22, 2010, 11:42 PM

Post #2 of 2 (6791 views)
Re: [ms10380] DBI::Oracle [In reply to] Can't Post

as the error describes

Can't load 'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll'

check for this file existence. look like the DBD::Oracle was not installed properly on the second machine.

The most rough way for windows (as possible solution) could be simple sync of C:/Perl/lib/ folder contents on both machines (or just copy the folder from good one to problematic one). If it does not help try to reinstall DBD::Oracle package due to it may use some libraries located in the system folders.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives