Hi, all,
Since I can't get Oracle Client 9i ot 10g, I just down grade my PERL to
5.6.1 Build 638, and try to connect to ORACLE 8i. However, I get the
following message:
"DBI connect('MAIN01','owner',...) failed: ORA-12154: TNS:could not resolve
the connect identifier specified (DBD ERROR: OCIServerAttach) at con_db.pl
line 9"
Does anyone know to solve this problem? Thanks
Angela
============================================================
The following is my perl program:
use strict;
use DBI;
my $dbh_target;
$dbh_target = DBI->connect('dbi:Oracle:MAIN01', 'owner', 'oracle')
or die "Can't connect to TARGET ODBC database
[Error:".DBI->errstr."]";
print "\tPPS TARGET database: $dbh_target\n";
=============================================================
The following is my TNSNAME.ora file setting:
MAIN01=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.90.58)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.90.59)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SDPA)
(FAILOVER_MODE = (TYPE= SELECT)(METHOD=BASIC))
)
)
