473,404 Members | 2,137 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Reuse Connect dialog box on forms 6i run time to connect to another database

Hello,

With regards to the Connect dialog on Oracle forms 6i via which we can
connect to Oracle database, should we use the same functionality on
forms run time again?
I mean, I want to make a window with three screen items for username,
password and service name. And on run time after connecting to the
database I use this window to reconnect to an other database.

So when I give the appropriate information, I will connect to the
required database.
I am using the following command on when button press, to connect to
database via forms but unfortunately this command runs only when the
standalone procedure builder invoke.

..CONNECT DB scott/tiger@test

Could you give me suggestion that how should I connect to required
database on forms run time?

Thanks

David
Jul 19 '05 #1
1 4748
da***********@yahoo.com (DAVID) wrote in message news:<db**************************@posting.google. com>...
Hello,

With regards to the Connect dialog on Oracle forms 6i via which we can
connect to Oracle database, should we use the same functionality on
forms run time again?
I mean, I want to make a window with three screen items for username,
password and service name. And on run time after connecting to the
database I use this window to reconnect to an other database.

So when I give the appropriate information, I will connect to the
required database.
I am using the following command on when button press, to connect to
database via forms but unfortunately this command runs only when the
standalone procedure builder invoke.

.CONNECT DB scott/tiger@test

Could you give me suggestion that how should I connect to required
database on forms run time?

Thanks

David


Please try to write down which are you functional requirements. Your
question seems to indicate you have absolutely zero idea what you are
doing and what databases are all about. If so, try to learn what an
Oracle database is, try to understand Oracle != Sqlserver, and/or hire
someone who can address your functional requirements.
In the meantime, please don't try to repost your current questions
over and over and over again. People here have been really trying to
understand what you are trying to accomplish. The problem is you
'think' you know the solution (which you don't) and we can't read your
mind, and understand what you are up to, other than create a big mess.

Regards

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

242
by: James Cameron | last post by:
Hi I'm developing a program and the client is worried about future reuse of the code. Say 5, 10, 15 years down the road. This will be a major factor in selecting the development language. Any...
0
by: anders thoresson | last post by:
Hi, I have this function I call everytime I need to make a query from within my php-scripts: function db_connect ($user, $pwd, $db, $debug = 0) { $link = @mysql_pconnect("localhost",...
7
by: hank | last post by:
Hi All In the Circular Logging when the Primary Log file fill up, the database manager will creat a secondary log files for the transaction; when this transaction finished, the secondary log...
0
by: Ragtimer | last post by:
I've been trying to build a DAO.QueryDef.Connect string, building it from a user ID and password string obtained previously by a log-in dialog box, using it to log in to an Oracle database through...
3
by: steph | last post by:
Hi, I've got below function to dynamically define and run pass-through queries. This works OK. But I don't want to have the connection string hard-coded, instead I want to reuse the existing...
1
by: JustMe | last post by:
Hi all, Although I've got quite a lot of experience with php and (M/My)SQL, I only used both within an online php script. These last few months I bought an option with my webhost to access...
11
by: Zytan | last post by:
I have created a new form from the main form. When I close the main form with the 'x' close button, its Form.FormClosed event is run, but not the dialog's. Is this normal? It is ok /...
5
by: GraffixNYC | last post by:
We have a model dialog box(well a bunch of them) and it seems that when you cancel one of the in our application it will activate and bring the focus to another open window (not in our application)...
1
by: DAVID | last post by:
Hello, With regards to the Connect dialog on Oracle forms 6i via which we can connect to Oracle database, should we use the same functionality on forms run time again? I mean, I want to make a...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.