Here is what I did:
eval {
$dbh = DBI->connect("dbi:$dbDriver:$dbName", $dbUser, $dbPass,
{ RaiseError => 1, PrintError => 1,
ora_envhp => 0 });
};
Still does not work.
Peter
-----Original Message-----
From: Alexander V Alekseev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 3:21 PM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: RE: ORA-12154: TNS:could not resolve the connect identifier
specified
Hello!
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 });
Bye. Alex.
This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.
