Promotic

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).
Note:
Property access for read and write. The default value of this property is defined in the "Additional parameters of database connection" configurator of this object.
See also:
- PmaAdo.DbOpen (method)
Example1:
JavaScriptVBScriptSelect and copy to clipboard

var sConnectParams = oDb.DbConnectionParams;
Example2:

History:
Pm9.00.02: New options "connectiontimeout:xxx;" and "commandtimeout:xxx;" that can be used to define the waiting time before connection or command execution.
Pm8.01.00: Created
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.