CANNOT connect to the DB via FMX file (ORA-12154)
398711Apr 19 2004 — edited Apr 22 2004Dear Colleague,
I have a configuration problem.
I receive the following error message when I try to connect to the DB:
ORA-12154
TNS could not resolve service name.
Facts:
1. I can start Forms Builder from the Windows XP menu, but CANNOT connect to the DB.
2. If I start Forms Builder from the directory in which the TNSNAME file for the DB resides (i.e. c:\oracle\ora92\network\admin), then I CAN connect to the DB.
3. However, when I compile and then run the form, the DB connection provided in the URL fails.
What configuration do I need to make to enable my form to access the DB at runtime?
Thanks in advance for your help!
Kind regards,
Randy