The TNS name for that database was never set up. tnsnames.ora file keeps
that info. Since you are on wintel, you might want to try ODBC. Set up a
DSN to your database and use dbi:ODBC:dsn_name convention.
Ilya Sterin
-----Original Message-----
From: VIDYASAGAR R NALLU [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 6: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
