Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forms

Status
Not open for further replies.

papakula

Programmer
Aug 21, 2001
33
GB
Hi all!
I had loaded developer and oracle8i on win98. Backend
is working out well. But Im not able to connect thru forms
it is giving error as TNS unable to connect destination.
Any Help
Many Thanks
Dar
 
Although I've not tried this myself so I could be talking rubbish, I believe you have to connect through a loopback TNS connection. In your TNSNAMES file there should be some sort of loopback already defined, with an IP address of 127.0.0.1. Try using that.

If that doesnt work directly, you may have to set up a listener.
 
A better approach for you should be to copy the backend's tnsnames and overwrite forms' tnsname and then delete sqlnet file. It should work for you. It did for me.
The loopback option won't work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top