RE: ORA-12154: TNS:could not resolve the connect identifier specified

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:alex@xxxxxxxxxx]
Sent: Wednesday, December 12, 2007 3:21 PM
To: Loo, Peter # PHX
Cc: dbi-users@xxxxxxxx
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.
.

Relevant Pages

  • Re: ISOs
    ... Las Vegas, NV / Beverly Hills, CA / Philadelphia, PA / Washington, DC ... Confidentiality Notice: This e-mail message, including any attachments, is ... you are not the intended recipient, please contact the sender by reply ...
    (freebsd-questions)
  • RE: Where are the selected rows stored using fetchall_arrayref
    ... Peter Loo ... This E-mail message is for the sole use of the intended recipient ... unauthorized review, use, disclosure or distribution is prohibited. ... you are not the intended recipient, please contact the sender by reply ...
    (perl.dbi.users)
  • Re: AIX 5.3 disaster recovery fro AIX newbie
    ... fro AIX newbie ... errors or omissions in this e-mail message. ... not the intended recipient or the individual responsible for delivering ... e-mail do not reflect the views of Blue Cross Blue Shield of Florida, ...
    (AIX-L)
  • ISOs
    ... Las Vegas, NV / Beverly Hills, CA / Philadelphia, PA / Washington, DC ... Confidentiality Notice: This e-mail message, including any attachments, is ... you are not the intended recipient, please contact the sender by reply ...
    (freebsd-questions)
  • RE: DBI->data_sources(Oracle)
    ... As far as I understand DBD::Oracle, ... This E-mail message is for the sole use of the intended recipient ... you are not the intended recipient, please contact the sender by reply ...
    (perl.dbi.users)