Check your ensure that MyOraDb exists in your tnsnames.ora file or
alternatively if using Oracle Names that it is in the Names database. Then
check the syntax of the tnsnames.ora to make sure everything is OK and that
the host name and port number for this database are correct. The ensure
that there is a listener running on your database server.
Neil
-----Original Message-----
From: VIDYASAGAR R NALLU [mailto:[EMAIL PROTECTED]]
Sent: May 11, 2001 3:16 PM
To: [EMAIL PROTECTED]
Subject: Problem connecting Oracle database
Hi all,
I wrote a program to connect to Oracle database with the following
statement:
my $dbh = DBI->connect("DBI:Oracle:MyOraDb","scott","tiger") or die
"Error: $DBI::errstr";
but i'm ended up with the following error message:
DBI->connect(MyOraDb) failed: ORA-12154: TNS: could not resolve service
name (DBD: login failed) at dbidemo.pl line 10
Error: ORA-12154: TNS: could not resolve service name (DBD: login failed)
provided DBI & DBD were installed using ppm tool.
Any help would be appreciated.
Thanks
Rajasree
