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" <[EMAIL PROTECTED]>
To: "Alexander V Alekseev" <[EMAIL PROTECTED]>
Cc: "Loo, Peter # PHX" <[EMAIL PROTECTED]>;
<dbi-users@perl.org>
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
>
