Home » Developer & Programmer » Forms » ...Connecting with database remotely ......
...Connecting with database remotely ...... [message #121392] Sat, 28 May 2005 02:18 Go to next message
orcl_dba
Messages: 84
Registered: March 2005
Member
Hi .. i have forms 6i on client machine and server have oracle 9.2 version...

I have connected from client to server through sqlplus and it is connecting ..

but from Forms to server it is not connecting ..

any input plz .

i have placed the client tnsnames file.. entry in the forsm
net80.. tnsnames ...


and i give usrname/paswrod@orcl.. orcl isthe service name that connects my client machine to server


it says..

Tns could not resolve service name
while through sqllplu it is connected

i can see the tables etc and everthing

waht is the science behind it ..

best regards

Report message to a moderator

Re: ...Connecting with database remotely ...... [message #121770 is a reply to message #121392] Tue, 31 May 2005 23:24 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I assume that you have built your connect string into a variable field of some type.

Use a message command to display this information from within your form. It may have been built with spaces in it.

David

Report message to a moderator

Previous Topic: Convert Text to Binary in Forms 9i
Next Topic: Displaying Menu in Web
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 11:13:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.