Maybe someone else remembers how to do this.
It has been some time since we used this method and I could no longer find
code referencing how it was used. I do remember that it was fairly simple
and technical support was more then addequate in getting it set up.
Somone on the tech support forumn may be able to chime in. What you simply
want to do is be able to set the runtime user and password to a value
stored in session and as a second step reset data source. Both of these
are probably covered in documentation.
Brian
[EMAIL PROTECTED] on 04/23/99 12:55:53 PM
To: Brian Hurysz/NYISO
cc:
Subject: Re: [ND] Connecting to an Oracle Database
Brian,
Thank you for your reply. I am still unclear, however, as to the
exact command used to specify the User ID and Pasword in the Oracle
Data Source at runtime. Could you please let me know the method used
to accomplishe this.
Thank You
David Wimsett
[EMAIL PROTECTED]
______________________________ Reply Separator
_________________________________
Subject: Re: [ND] Connecting to an Oracle Database
Author: Non-HP-bhurysz ([EMAIL PROTECTED]) at HP-Sonoma,mimegw215
Date: 4/22/99 6:04 AM
Resetting the datasource before every data object execution is a viable
solution that some users have done. The drawbacks we found with this
approach are 1) you suffer a reconnection time with every data object
execution that on our system was something less then a second, 2) had to
make sure the reset code did in fact catch every data object, and 3) a
general concern that between the time a data source was reset and a data
object executed another user may hit a page and reset the data source
causing dispaly of confidential information. Technical support was very
good with supporting us when we originally had our application set up this
way and you may wish to give them a call. Other users also commented that
they were implementing this approach and very happy with it. We no longer
use it.
[EMAIL PROTECTED] on 04/21/99 05:31:06 PM
To: [EMAIL PROTECTED]
cc: (bcc: Brian Hurysz/NYISO)
Subject: [ND] Connecting to an Oracle Database
My project connects to an ORacle 8 database. I have created a data source
and data objects. When I created a data
source I entered a User ID and Password. This allows me to access the
database and retrieve rows with no trouble.
Now, I am writing the login front end. I have an HTML page with one text
box for the User ID and another for the Password.
The page also has a static text field for error messages and a button
labeled Login.
Due to design considerations, we must have a seperate User ID for each
individual accessing the database.
I have two questions.
1) How do I setup the Password text box to display asterisks like an HTML
<INPUT TYPE=PASSWORD NAME="PW> field.
2) How do I use the User ID and Password entered by the operator to access
the database. I have considered
placing it in the RuntimeUserID and RuntimePassword properties of the
data source, but don't know the command to
do so. I have also looked for some kind of inline command issued when
opening the database, but cna't find any
reference to one.
Does anyone hav some ideas?
Thank You
David Wimsett
[EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
