Re: Connecting Forms to database
Date: Fri, 05 Sep 2003 18:19:33 -0700
Message-ID: <FCa6b.113703$kP.41446_at_fed1read03>
Pinaki wrote:
> Hi everybody,
> I'm using Oracle 9i,Release 2,Developer Suite.I have
> also installed the database.Connection in the database(9i,Release 2)
> is not creating any problem.I can log in through sqlplus.But, when I
> try to connect through the Forms Developer...it says...ORA-12154 (TNS
> cannot resolve service name).But the tnsnames.ora file seems to
> allright and in proper place.What could cause the problem.Is
> installation of Application Server necessary for connecting forms to
> the database???
>
> Thanks,
> Pinaki
It ALWAYS helps to specify the OS & Version.
FWIW - If you have multiple ORACLE_HOME directories, you'll have multiple TNSNAMES.ORA files. I strongly suspect that iDS has a different home than SQL*plus; and therefore success with SQL*Plus is not relevant to a network connect from iDS. Received on Sat Sep 06 2003 - 03:19:33 CEST