OraFAQ Forum: Forms » Strange Error When Connecting Form 6i

Home » Developer & Programmer » Forms » Strange Error When Connecting Form 6i (Oracle Forms, 6i release 2, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Strange Error When Connecting Form 6i [message #322113]

Thu, 22 May 2008 09:31

orafellow
Messages: 3
Registered: May 2008

Junior Member

I am getting an strange error for last some days, I dont know is it the error of my application or logic or forms runtime.

I developed a simple form where I wrote a trigger on ON-LOGON event, i wrote a code to login into the database the code was "LOGON('USERNAME','PASSWORD@SERVICE');", when I run the form through form builder it works fine, when I use a short cut to run the form it gives me errror, first it shows the authentication window when i type username and password it gives me TNS error I dont know why, a some days ago it was working fine now it is giving me trouble.

Please help me to resolve this problem.

regards

Report message to a moderator

Re: Strange Error When Connecting Form 6i [message #322128 is a reply to message #322113]

Thu, 22 May 2008 10:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What has changed since it worked correctly? Did you, perhaps, change this user's password?

Report message to a moderator

Re: Strange Error When Connecting Form 6i [message #322288 is a reply to message #322128]

Fri, 23 May 2008 00:27

orafellow
Messages: 3
Registered: May 2008

Junior Member

I didn't change any thing,username and password are still same. Two or three months ago it was working fine and the old compiled forms are still working but the new forms do not work.

The more strange thing is, I created a form with only one trigger on ON-LOGON event I wrote a code to connect to the database the form is working fine on form builder but when i run it through shortcut it gives me error which is attached.

Do I need to install any patch or some thing else, I recently downloaded Oracle Forms 6i from Oracle web site and using this product to develop form i donno is it the problem of windows or forms but very irretating.

Please help me.......

Attachment: problem.JPG
(Size: 7.33KB, Downloaded 567 times)

Report message to a moderator

Re: Strange Error When Connecting Form 6i [message #322350 is a reply to message #322288]

Fri, 23 May 2008 03:37

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, there's no listener there.

Oracle

ORA-12224: TNS:no listener

Cause: The connection request could not be completed because the listener is not running.

Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

Report message to a moderator

Re: Strange Error When Connecting Form 6i [message #322364 is a reply to message #322350]

Fri, 23 May 2008 04:27

orafellow
Messages: 3
Registered: May 2008

Junior Member

Listener is there, SQL plus works with the same Name Service, only shortcut gives error.

Report message to a moderator

Re: Strange Error When Connecting Form 6i [message #322961 is a reply to message #322364]

Mon, 26 May 2008 23:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do you have a different directory in the 'start in' for the 'Run' shortcut versus the 'Forms Builder' shortcut?

David

Report message to a moderator

Previous Topic:	How to get cummulative sum of a column
Next Topic:	ORA-23401 materialized view "string"."string" does not exist

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 23:20:14 CST 2025