If the "Allow dynamic connection using the transaction LogID and LogPass" option (equivalent to the "DynamicConnection" setting) in the database cache is enabled, the application will either use the LogID and LogPass property values of the Transaction object or the UID and PWD values in the ConnectString DBParm parameter to log in to the database server (instead of using the values in the User name and Password fields of the cache). This makes it possible that the installable cloud app connects to the database based on the user credentials provided at runtime.
When connecting to the database through the ODBC driver, the Transaction object uses the UID and PWD values in the ConnectString DBParm parameter to log in to the database; when connecting to the database through a direct connection, the Transaction object uses its LogID and LogPass property values to log in to the database; as shown in the following table. "Direct connection" means connecting with the database using the information at the client app. The connection information is sent from the client app to the PowerServer Web APIs when PowerServer connects with the database.
| DB type | Connection type | User credentials used for dynamic connection |
|---|---|---|
|
ASA ASE Informix MySQL Oracle PostgreSQL SQL Server |
ODBC connection |
UID and PWD in the ConnectString DBParm parameter For example, SQLCA.DBParm = "ConnectString='DSN=PB Demo DB V2022;UID=dba;PWD=sql',driver='SqlAnywhere'" |
|
Informix Oracle SQL Server |
Direct connection |
LogID and LogPass of Transaction object For example, SQLCA.LogId = "sa" SQLCA.LogPass = "Appeon123!@#" |
