Re: Developer 2000 to connect Oracle Personal 8.1.6

Correct, but incomplete.
1) the beq protocol does not require a listener, it is Win only. 2) Dev/2000 is a version 7 tool, and uses %DEFAULT_HOME%\network\admin for net
  config files, whereas 8i uses %oracle8i_home%\network\admin   (V8 tools use %oracle_home%\net80\admin - not used here.) Probably, the original poster *can* connect using the sqlplus of oracle 8i (or
svrmgrl for that matter), but not with any of the V7 tools (plus33, plus33W, forms4.5).

2 possible solutions:
- copy your network config files to the correct diry (make backup
copies!)
  most important: tnsnames.ora. Also, try sqlnet.ora. Should be no need for
  a listener, so leave listener.ora for what it is.
- make all of Oracle look in one specific diry, by adding tns_admin to
the
  environment. For MS Win, that would be the registry:   HKLM\Software\Oracle, add string 'tns_admin', value 'your one and only net diry'
  (without the quotes, obviously...)
  If you do that, and it works, delete all .ora files in the *other* net... diries

-- 
Gtrz,

Frank van Bortel