The tns.ora that i have ..
C:\OraclePersonal\network\admin\tnsnames.ora has following...
MYORACPN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MyOracPn)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
The Oracle Service is running fine too. Please help!
Hey Thanks! I just got time to look at it.
As we discovered , it was the problem with multiple homes. I changed the default home to the Personal edition Oracle8i and the database is getting connected from the that directory.
I am trying to use data blocks in form to base the table in the oracle8i edition. I must mention that forms and Reports6i was installed on another directory which apparently seem to be having its own HOME which is also reflected in the registry. But when i try to use Form builder to connect to the database which is in another HOME gives me the TNS:Could not resolve service name. I am new to this. Could you help me in resolving this problem.
MUCH THANKS.