Following is the query:
After installing the following
1. Oracle9i installed (Both Client and server)
2. Installed Active perl 5.6
3. Installed DBI 1.37
4. Installed DBD-Oracle 1.12
With this installations when i tried to connect to Oracle database using DBI->Connect,
this function fails.
As i am a beginner to Perl and also to the Oracle9i m not able to debug and trace the
actual cause.
I have created the local database, ubrprod, entry in the tnsnames.ora is as follows:
UBRPROD.CYBAGE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mohini)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ubrprod)
)
)
following is the code used to connect to database
use DBI; # Load the DBI module
$dbh = DBI->connect("dbi:Oracle:host=localhost;sid=ubrprod;port=1521","scott","tiger")
|| die "can not connect::",$DBI::errstr;
exit;
Running this perl results in connection error saying
DBI connect('host=localhost;sid=ubrprod;port=1521','scott',...) failed: at
G:\perltests\test_ora.pl line 8 can not connect:: at G:\perltests\test_ora.pl line 8.
I need help to solve this problem.
Thanks,
Mohini.
---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
