Re: unable to connect to DB from DEV2000

Jane Williams wrote:

> On Sun, 17 Jun 2001 13:11:35 +0100, "michael.cooke"
> <michael.cooke_at_tinyworld.co.uk> wrote:
>
> >Have just installed Oracle 8.1.7 onto NT4.0 sp4 and am unable to connect to
> >it from Developer 2000 [forms 4.5 reports2.5]. I installed Dev 2000 first
> >due to its trying to use same oracle home as 8i if that installed first.
> >With Oracle 7.3.3 both were had same home and worked immediately.
> >I get an error 'no interface driver installed' . I believe it to be a
> >problem in TNSnames and/or listener or even registry entry.
> >Any help would be appreciated.
>
> I'm only guessing here, as I haven't played with Oracle 8i yet, but:
>
> Dev 2000 expects TNSNAMES.ORA to be in a directory called
> \network\admin
> Forms 6i expects TNSNAMES.ORA to be in a directory called \net8\admin
>
> Could Oracle 8i be putting it in \net8, not \network?
>
> This of course raises the question of which version of SQL*Net you're
> trying to use: 2 or 8? (8 works fine with DEV 2K: I'd be surprised if
> 2 worked with O8i).

You are correct. But Oracle keeps multiple copies of tnsnames.ora. Each in a separate directory under a separate home. And each must contain a valid entry for each database to which you connect.

Daniel A. Morgan Received on Sat Jul 21 2001 - 23:53:44 CEST