paragkalra has asked for the wisdom of the Perl Monks concerning the following question:
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?
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Connecting to Oracle Database using Perl & ODBC Driver.
by Anonymous Monk on Sep 16, 2009 at 15:17 UTC | |
|
Re: Connecting to Oracle Database using Perl & ODBC Driver.
by Anonymous Monk on Nov 23, 2009 at 01:42 UTC |