OraFAQ Forum: Forms » Regarding Multiple database

Home » Developer & Programmer » Forms » Regarding Multiple database

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

Regarding Multiple database [message #225982]

Thu, 22 March 2007 03:09

srinivasan83
Messages: 7
Registered: March 2007
Location: coimbatore

Junior Member

hi friends,
i`m developing the application using oracle forms 9i ..
Here i have multiple database named like production,site etc....Now i need to display these database names in list box of login form.. User have to choose the database name from list box. i don`t know anything how can i do this ...please explain me with example.. reply as soon as possible
like below structure

Username :text box
password :text box
database : here list box show all the database names..

Report message to a moderator

Re: Regarding Multiple database [message #226211 is a reply to message #225982]

Thu, 22 March 2007 20:36

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

Senior Member
Account Moderator

Search this forum for 'login' and 'logon'. There are numerous threads. Start with the older ones.

Unless you have an Oracle Management Server running you will have to hardcode the list of databases or you will have to sign on to a database, read from a list of databases, and then ask the user to signon to the database in which they wish to work.

David

Report message to a moderator

Re: Regarding Multiple database [message #226555 is a reply to message #226211]

Sun, 25 March 2007 00:52

srinivasan83
Messages: 7
Registered: March 2007
Location: coimbatore

Junior Member

i have tried using the login logon key word but i cant find the result for my question... send me with an example so that it will be easy for me to work...

Report message to a moderator

Re: Regarding Multiple database [message #226703 is a reply to message #225982]

Mon, 26 March 2007 04:40

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

Hi!!

Hope this will solve your problem.

I have created a text file. In that I have put database names and read it in the list item.

My scenerio was this:

File Name : databases.txt
ORCL
ORCL10g
ORCLNEW

Please file path also at your end.

Bhupinder Singh

Attachment: connect.fmb
(Size: 56.00KB, Downloaded 1058 times)

Report message to a moderator

Re: Regarding Multiple database [message #227001 is a reply to message #226703]

Tue, 27 March 2007 01:51

srinivasan83
Messages: 7
Registered: March 2007
Location: coimbatore

Junior Member

thanks it works.. But i can`t understand your logic.. because it show two login forms i have attached the file. in that file has those two files..
can you explain why it show two login windows..

Attachment: Actually I logged on before running.doc
(Size: 160.50KB, Downloaded 1370 times)

Report message to a moderator

Re: Regarding Multiple database [message #227060 is a reply to message #227001]

Tue, 27 March 2007 04:14

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

It is not suppose to be used as it is.

I would suggest following in your case.
1) Run the form with NULL in ON-LOGON
2) Connect to the database on clicking 'Connect' in your form.

Bhupinder Singh

Report message to a moderator

Previous Topic:	Datablock not assosicated with the database on forms 10G is giving me FRM-40401
Next Topic:	Call form , can't find the form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 23:43:32 CDT 2025