DbConnectionParams - property of object PmaAdo
Additional parameters of database connection.
DbConnectionParams As String
s = oDb.DbConnectionParams
Additional parameters of database connection by the DbOpen
method represented by string. Entries are in KeyVal
format, for example "connect:async;connectiontimeout:30;commandtimeout:60;"
- Specifies the connection type. The default is synchronous
connection, i.e. the method will execute the connection and wait for operation result.
- Asynchronous connection, i.e. the method will create the connection request and does not wait for result. Corresponds to the ADO adAsyncConnect
Caution: Asynchronous programming frequently causes comlications, therefore it is recommended to use the synchronous attitude. If there is a chance, that the synchronous requests may take too much time and there is a possibility of timeout, then it is recommended to execute all operations in the working thread (See PmaSequencer").
"connectiontimeout:xxx;" (optional) - Specifies the number of seconds to wait before the connection is opened (default is 15 seconds).
"commandtimeout:xxx;" (optional) - Specifies the number of seconds to wait before the command is executed (default is 30 seconds).