Promotic
WikipediaLinkedInYoutubeTwitterFacebook

DbConnectionParams - property of object PmaAdo

Description:
Additional parameters of database connection.
Syntax:
String DbConnectionParams
Calling:
s = oDb.DbConnectionParams
Values:
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;".
"connect:xxx;" (optional) - Specifies the connection type. The default is synchronous connection, i.e. the method will execute the connection and wait for operation result.
async - Asynchronous connection, i.e. the method will create the connection request and does not wait for result. Corresponds to the ADO adAsyncConnect value.

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).
Note:
Property access for read and write. The preset value of this property is defined in the "Additional parameters of database connection" configurator of this object.
Example:

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.7 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice