DbConnectionParams - property of the PmaAdo object
Description:
Additional parameters of database connection.
Syntax:
String DbConnectionParams
Values:
Additional parameters of database connection by the
DbOpen method in the form of a text string.
Entries are in the
KeyVal format, for example
"connect:async;connectiontimeout:30;commandtimeout:60;".
"connect:xxx;" (optional) - Specifies the connection type. The default is
synchronous connection, it means that the method will execute the connection and wait for operation result.
async - Asynchronous connection, it means that the method creates the connection request and does not wait for result. Corresponds to the
ADO adAsyncConnect value.
Caution: Asynchronous programming frequently causes comlications and 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 object").
"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).
Example1:
JavaScriptVBScriptSelect and copy to clipboard
var sConnectParams = oDb.DbConnectionParams;
Dim sConnectParams
sConnectParams = oDb.DbConnectionParams