Home » Developer & Programmer » Forms » Regarding Multiple database
Regarding Multiple database [message #225982] Thu, 22 March 2007 03:09 Go to next message
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..
Re: Regarding Multiple database [message #226211 is a reply to message #225982] Thu, 22 March 2007 20:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Regarding Multiple database [message #226555 is a reply to message #226211] Sun, 25 March 2007 00:52 Go to previous messageGo to next message
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...
Re: Regarding Multiple database [message #226703 is a reply to message #225982] Mon, 26 March 2007 04:40 Go to previous messageGo to next message
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 207 times)
Re: Regarding Multiple database [message #227001 is a reply to message #226703] Tue, 27 March 2007 01:51 Go to previous messageGo to next message
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..
Re: Regarding Multiple database [message #227060 is a reply to message #227001] Tue, 27 March 2007 04:14 Go to previous message
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
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:
  


Current Time: Fri Dec 09 02:16:26 CST 2016

Total time taken to generate the page: 0.12797 seconds