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.
.

Relevant Pages

  • Re: Using Oracle Internet Directory (OID) instead of TNS Names
    ... Loo, Peter # PHX wrote: ... logging on to it. ...
    (perl.dbi.users)
  • Re: Named pipe
    ... Loo, Peter # PHX wrote: ... I was wondering if anyone might have an answer as to how I can sync the ...
    (perl.dbi.users)
  • Re: DBI->data_sources(Oracle)
    ... On 02.05.2006 20:15, Loo, Peter # PHX wrote: ... One of my severs that I am trying to connect to is NOT listed in ...
    (perl.dbi.users)
  • RE: sth->do()
    ... Loo, Peter # PHX wrote: ... the process of prepare and execute. ...
    (perl.dbi.users)
  • Re: Update cant work behind Linksys wireless router. Direct to AD
    ... Not sure what type of DSL connection your ISP offers but, see if this applies, Peter: ... Some 'thing' is blocking the connection to the update server. ... If the system can update successfully when connected directly to the modem than the Linksys router needs to have some settings adjusted. ...
    (microsoft.public.windowsupdate)