OraFAQ Forum: Forms » Logon to another database

Home » Developer & Programmer » Forms » Logon to another database

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

Logon to another database [message #431555]

Wed, 18 November 2009 02:14

sysman2007
Messages: 24
Registered: March 2009

Junior Member

in my form I have 2 radio button and want when user click on it
connection change from this database to another database?
I try to do this whit LOGOUT and LOGON but don't work.
for example when user click on 1th radio button connect to 1th database
and when user click on 2th radio button connect to 2th database

Report message to a moderator

Re: Logon to another database [message #431568 is a reply to message #431555]

Wed, 18 November 2009 03:50

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

Senior Member
Account Moderator

Wouldn't you rather do that during connection to the application? You have to supply username, password and database you are connecting to. So ... why not?

Report message to a moderator

Re: Logon to another database [message #431592 is a reply to message #431568]

Wed, 18 November 2009 06:21

sysman2007
Messages: 24
Registered: March 2009

Junior Member

I use 2 database in 2 servers but username and password of users in
2 servers is same as other.
I want help users to prevent 2 times logon an enter 2 times username and password.

Report message to a moderator

Re: Logon to another database [message #431626 is a reply to message #431592]

Wed, 18 November 2009 10:21

snsiddiqui
Messages: 172
Registered: December 2008

Senior Member

Dear
You should use DBLINK instead of LOGOUT and LOGON.

Report message to a moderator

Re: Logon to another database [message #431997 is a reply to message #431555]

Fri, 20 November 2009 05:52

dshakthi
Messages: 5
Registered: January 2008
Location: Bangalore

Junior Member

please try this

declare
un varchar2 (10) := 'aaaa';
pw varchar2 (10) := 'bbbb';
cn varchar2 (10) := 'cccc';
aa varchar2 (100);
begin
logout;
logon (un, pw || '@' || cn);
select name into aa from v$database;
message ('database ' || aa);
message (' ');
end;

Report message to a moderator

Re: Logon to another database [message #432071 is a reply to message #431997]

Fri, 20 November 2009 22:11

sysman2007
Messages: 24
Registered: March 2009

Junior Member

I use this codes
but I get error FRM-92101 when want LOGON to new database

FRM-92101: There was a failure in the forms Server during startup.This Could happen due to invalid configuration
Please look into the web-server log file for details.

Details
Java Exception
oracle.forms.net.connectionException: Forms session <25> aborted: unable to communicate with runtime process.
at oracle.forms.net.connectionException:createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)
at oracle.forms.net.HTTPNStream.doflush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DateOutputStream.flush(Unknown Source)
at oracle.forms.net.StreamMessageWritter.run(Unknown Source)

Report message to a moderator

Re: Logon to another database [message #432242 is a reply to message #432071]

Mon, 23 November 2009 03:25

dshakthi
Messages: 5
Registered: January 2008
Location: Bangalore

Junior Member

try this out

Attachment: post.JPG
(Size: 96.17KB, Downloaded 691 times)

Report message to a moderator

Re: Logon to another database [message #432449 is a reply to message #432242]

Tue, 24 November 2009 05:27

sysman2007
Messages: 24
Registered: March 2009

Junior Member

thanks but didn't work

Report message to a moderator

Re: Logon to another database [message #433366 is a reply to message #432449]

Tue, 01 December 2009 23:40

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

Senior Member
Account Moderator

Have you solved your problem?

If not, try saving the username and password BEFORE doing the 'logoff', then use that information as part of the new 'logon'.

David

Report message to a moderator

Previous Topic:	Validation
Next Topic:	Forms multi-row validation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:50:18 CDT 2024