Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting to Oracle Database using Perl & ODBC Driver.

572704Sep 15 2009 — edited Sep 15 2009

Hello All,

First I downloaded Oracle 10g client and using net manager successfully tested the connection with remote database.

The using Windows ODBC driver administrator, I added the client instance which I installed above and here also successfully tested the connection with remote Oracle database.

The I wrote a PERL script and tried to connect to same remote database with the help ODBC driver (DBI:ODBC:<ODBC_Instance_name> ) but I am getting following error:

DBI connect('OraClient10g_home2','testuser',...) failed: Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g_home2). (SQL-IM

003) at Test_DB.pl line 116

Could not connect to remote database - Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g_home2). (SQL-IM003)

Any pointers?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2009

Added on Sep 15 2009

#general-database-discussions

1 comment

1,245 views