Promotic

Parameters for type: MS SQL database - configuration window

Description:
The window serves for setting the parameters for the data storage into the MS SQL database.
This type of saving is suitable especially for local event group (server) where the event group represents a place in the application where the event items really originate and are stored to the database for viewing purposes. The window serves for setting the parameters for database connection and also for setup of the database table parameters (e.g. the maximum table size). Each time the maximum number of records in the database table is exceeded the oldest records are automatically deleted.
In the case of a remote event group (see the "Remote group (client)" configurator), it sets the way of getting the data for the history viewer by file sharing . The simplest way, in this case, is to use the data sharing of an event group by means of the "Remote connection via the Web" configurator where the event history viewer is functional automatically.
Configurators:
Data source (ConnectionString)The ADO ConnectionString (http://www.connectionstrings.com) contains all necessary parameters needed by the ADO Connection object for database connection via the selected ADO Provider.
Macro expression can be used for input (it is evaluated after the application is launched). This configurator must not contain an empty string. For example "Provider=SQLOLEDB;Server=.\MSSQLSERVER;Database=pm_data;Uid=pm_writer;Pwd=pmwriter;"
Additional parametersAdditional parameters for storing. Entries are in the KeyVal format, for example "par1:value1;".
Macro expression can be used for input (it is evaluated after the application is launched).
TableName of the table in the database into which the data are stored.
Macro expression can be used for input (it is evaluated after the application is launched).
Maximum number of records (-1 = unlimited)Maximum size of the table specified by the records count. When the maximum limit is exceeded the oldest records are deleted.
The -1 value means that the maximum size of the table is not limited by the records count.

History:
Pm9.00.00: Created
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

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