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

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
.