Re: Developer 2000 connection problems

Frank van Bortel wrote:

> Henry Hayden wrote:
> >
> > I'm using Oracle 8.1.5, and am able to connect via SQL*Plus.
 OK Thta's good.
> > I've also installed Developer 2000,
> Version would be handy...
>
> > Fatal OSN connect error 12154, connecting to:
> > yankee
> >
> > VERSION INFORMATION:
> > TNS for 32-bit Windows: Version 2.3.2.1.0 - Production
> OK - that's enough.
>
> What we have here is the fatal version clash:
> - Oracle 8.1.5 (btw Upgrade to 8.1.7 asap!) uses net8
> - you unknown version of Developer is an Oracle7 tool and uses SQL*Net
> V2.3,
> as indicated in the log.
> Oracle (you're supposed to look up devotely now!) in it's infinite
> wishdom
> decided to change directory names for the versions:
> V2.3 looks in %DEFAULT_HOME%\network\admin
> V8.0 looks in %DEFAULT_HOME%\net80\admin
> V8.1 looks in %8i_HOME%\network\admin
>
> Start to see the problem?
> You can connect using the (V8.0) sqlplus. That uses net8i (3rd entry
> above)
> for it's configuration files.
> Developer uses net V2.3, which looks in another diry (1st entry).
>
> Two ways to circumvent this:
> - tell V2.3 net to look somewhere else (my preferred method):
> introduce tns_admin in HKEY\Software\Oracle, using regedit or
> regedt32.
> It's a string (menu: add string value), pointing to the diry where
> to find the config files (tnsnames.ora, sqlnet.ora, etc).
> This way, you'll only have one location to update
> - copy working solutions from the V8i network config files to the
> V2.3 location (watch out for new options in V8+!)
>
> --
> Gtrz,
>
> Frank van Bortel

Franz-

Thanks! I will give this a try. Viele dank!

Henry Received on Sat Oct 13 2001 - 20:56:39 CEST