password control in Oracle

[jean-yves sarag]

Hello,
How can I establish a connection to an oracle dabase, when the userid and password are not in a table , BUT defined as oracle users??
Brgds /jean-yves

[Mark]

Jean-Yves,
If I understand you correctly, you need to use variables for the UserId and Password? Just put those variables into your dbSQL statement, something like
this:

Mydb.dbSQL = "DSN=DSNName; UID=" & USERID & ";PWD=" & PASSWORD & ";"

(I assume you have already asked the user to enter his USERID and PASSWORD.)

Is that what you mean?

Mark.




------------
jean-yves sarag at 7/6/00 11:35:54 AM


Hello,
How can I establish a connection to an oracle dabase, when the userid and password are not in a table , BUT defined as oracle users??
Brgds /jean-yves