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 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 better 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).
var sConnectParams = oDb.DbConnectionParams;