Re: ORA-12154: TNS:could not resolve the connect identifierspecified

Good Evening Peter

since you're dealing with 2 completely different binaries (particularly
important when using Type 2 Oracle drivers)
You *may* want to consider a OOA/OOD solution e.g.
ConnectionTemplate (class)
Connection1 inherits from Template
Connection2 inherits from Template
main instantiates Connection1 using oracle-tns1(connection parameters) with
Oracle_9_driver1
instantiates Connection2 using oracle-tns2(connection parameters)
with Oracle_10_driver2

Viel Gluck/
Martin-
P.S. in any event follow tims advice and read the FINE manual

----- Original Message -----
From: "Tim Bunce" <Tim.Bunce@xxxxxxxxx>
To: "Alexander V Alekseev" <alex@xxxxxxxxxx>
Cc: "Loo, Peter # PHX" <Peter.Loo@xxxxxxxxxxxxxxxxxxxxxxxx>;
<dbi-users@xxxxxxxx>
Sent: Wednesday, December 12, 2007 5:43 PM
Subject: Re: ORA-12154: TNS:could not resolve the connect
identifierspecified


On Thu, Dec 13, 2007 at 01:20:38AM +0300, Alexander V Alekseev wrote:
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:

Hi Martin,

I tried setting both variables at the very beginning before any
connection is made and the result is still the same.

$ENV{ora_envhp} = 0;
$ENV{ORA_ENVHP} = 0;

ora_envhp is one of "Connect Attributes" (as stated in perldoc
DBD::Oracle). Therefore it must be passed to DBI->connect() call like
this:

my $dbh = DBI->connect($dsn, $user, $password,
{ RaiseError => 0, AutoCommit => 0, ora_envhp=> 0 });

As documented in the fine manual.

Tim.

http://www.catb.org/~esr/faqs/smart-questions.html


.