Re: Problem connecting to 8i on same machine

From: <happychappy_at_my-deja.com>
Date: Thu, 16 Nov 2000 15:26:50 GMT
Message-ID: <8v0ubf$ek1$1@nnrp1.deja.com>

In article <8v0t11$df0$1_at_nereid.worldonline.nl>, "Peter" <P.Slingerland_at_IMN.nl> wrote:
> Thanks for your reactions. I tried the suggested solutions before.
But still
> the same
> TNS No such protocol adapter error. If these weren't set correctly
the error
> would be
> something like TNS Could not resolve service name. I finally found
the cause
> of the error.
> The Oracle 8i installation has added a entry to the autoexec.bat
>
> 'set oracle_home = f:\oracle\ora81'. (Why use autoexec.bat on an NT
machine
> ??????? ).
>
> This entry overrules all other registry settings and, as it seems,
causes
> the SQLNET 8.04
> interface to look for the protocol adapters in the Oracle 8.1.5 home.
These
> probably are
> of the wrong type or verion, and cause the protocol adapter error.
Removing
> the oracle_home
> line in autoexec.bat fixes things completely.
>

Ta for the info I'll remember to watch out for autoexecs

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 16 2000 - 09:26:50 CST