App.DB.Connect

Databases
1

I support this code:

App.DB.DatabaseName = DbName // open new Oracle Database connection
App.DB.UserName = User
App.DB.Password = Pass
If Not App.DB.Connect() Then
MsgBox App.DB.ErrorMessage
Quit
End If

but do not understand how it works. DbName, User, & Pass are all properties of a class that get set from the login form but I do not see a table in the database that stores username and passwords, so am confused how this works. Can anyone explain the App.DB.Connect? Where does it look for credentials?

2

The login creditials are not stored in a publicly available table (not even sure if it is EVER visible, but I know it IS encrypted)

The DB.CONNECT function passes those values to the Database engine, and internally it decides if the CONNECT will succeed or fail

3

Thx Dave!