Re: unable to connect to DB from DEV2000
Date: Sun, 17 Jun 2001 13:00:37 GMT
Message-ID: <3b2ca95e.496067_at_pubnews.netcom.net.uk>
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). Received on Sun Jun 17 2001 - 15:00:37 CEST