SQL*Net & Developer 2000 networked app

From: Dave Peckham <davep_at_natinst.com>
Date: 1996/08/16
Message-ID: <32149A67.1C2D_at_natinst.com>#1/1


Here's a weird one...

I installed SQL*Net onto a computer that has never had Oracle installed on it so that I could see which files had been installed. There was the Oracle.ini, 5 DLLs in Windows\System, and the Oracle home (c:\orawin). So, I moved the Oracle home to a network volume (\\monsoon\temp). Then I copied our standard tnsnames.ora to the networked oracle home (\\monsoon\temp\orawin). Then I edited the local oracle.ini, changing all reference to c:\orawin to \\monsoon\temp. When I try to use it though, I get a tnsnames lookup failure.

That may all seem normal, but then I went to my machine which runs Oracle & SQL*Net successfully. I deleted my oracle.ini and c:\orawin directory. Then I copied the oracle.ini from the computer mentioned above. I tried SQL*Net again, and it works! This is weird because I have no tnsnames on my computer and am using the same oracle.ini.

What is going on?

Dave

-- 
PS-What I am really trying to accomplish is a way to have my users using
my dev 2000 apps from the server without too much on their hard drives
and without running the oracle installer on each of their machines.
________________________________________________________________________
Dave Peckham
IS Programmer/Analyst                           dave.peckham_at_natinst.com
National Instruments                              http://www.natinst.com
Received on Fri Aug 16 1996 - 00:00:00 CEST

Original text of this message