Re: Run form6i against 8i dbms on the same machine

The 2 tools will look in different places for the tnsnames.ora file, so you need to be sure both of them are correct ( c:\oracle\form61\network\admin and c:\oracle\ora8i\network/admin would be the default locations in your setup) A better way, in my opinion, is to add the following to the registry : In
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE add a string value of TNS_ADMIN
and in it specify the location of the place where you want Oracle ( all tools) to look, for instance
add TNS_ADMIN make its data : c:\oracle\ora8i\network\admin

( as usual be careful when editing the registry...if unsure, don't )

hth,

Wai Tak Sit <wtsit_at_attglobal.net> wrote:

>Hi,
>
>I have Oracle 8.1.6 Enterprise Edition and Form6i on the NT machine. The
>oracle home for dbms is c:\oralce\ora8i. The Forms home directory is
>c:oracle\form6i (the installer does not allow both Forms6i and DBMS on
>the same directory). I can access the 8i database using SQLPlus of the
>DBMS. But I cannot access the 8i database from the Forms client SQLplus,
>i.e. I cannot run Forms against the dbms. I read about the need of
>changing some setting in the server's and client's tnsnames.ora But I do
>not know how.
>
>please help.
>
>Thanks a lot.
>
>WT
Received on Wed May 02 2001 - 18:02:40 CEST