Re: Developer 2000 connection problems

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