Re: Connecting Forms to database

Hi,

[Quoted]        I am using Windows 2K(Professional)...I have two tnsnames.ora [Quoted] files.One for the DB and one for forms.But the one for forms looks ok(it's been generated by the Net8 configuration tools) and they are definitely in two different homes.
Any help would be really appreciated...

Thanks,
Pinaki

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<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 - 10:42:54 CEST