DbConnectionParams - property of the PmaAdo object
Additional parameters of database connection.
Additional parameters of database connection by the DbOpen
method in the form of string. Entries are in the KeyVal
format, for example "connect:async;connectiontimeout:30;commandtimeout:60;"
- Specifies the connection type. The default is synchronous
connection, it means that the method will execute the connection and wait for operation result.
- Asynchronous connection, it means that the method will create the connection request and does not wait for result. Corresponds to the ADO adAsyncConnect
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 better to execute all operations in the worker thread (see the 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).
var sConnectParams = oDb.DbConnectionParams;