Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Preconfiguration "PmaAdo - ADO database"

Creates PmaAdo object.
 
This preconfiguration can be activated when creating a new object (e.g. by "New object ..." in the local object menu or after pressing the Insert key after selecting the object) and is included in the group: " / Basic".

This preconfiguration can be used with the objects: PmaFolder or PmaRoot.

These configurators can be set before the preconfiguration is created:
The name of created objectName of the object created in the tree of Pma objects. The maximum name length is 30 characters. This is a system name, so it must contain only alphanumeric and must not contain any diacritics, empty string, spaces and the first character must not be a number.

Default: "PmaAdo".

Database connection parametersDatabase connection parameters by the DbOpen method in the form of ADO 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. The typical parameters are represented for example by connection provider (provider), server address (server), database name (database), login name and password (uid, pwd), etc. The parameter list and exact syntax is defined by the corresponding ADO Provider, parameters may differ by individual ADO Providers. However for the sake of compatibility most providers ADO Provider understand multiple names of the main parameters simultaneously (e.g. the database name can be represented by database, data source, dbq, etc.). Caution: The syntax of this string is different than other strings used in the PROMOTIC system, the value and the name are separated by =, not by "colon" (:). Entries with assigned value are separated by a semicolon, for example "provider=SQLOLEDB;server=.\SQLEXPRESS;database=pm_data;uid=pm_admin;pwd=pmadmin;".

This configurator sets the initial value of the DbConnectionString property.

Macro expression can be used for input (it is evaluated after starting the application).

Values can be edited manually, or created by the button on the right, that will open the window for Window of recommended settings of the connection string.

The defined parameters may not always be valid (for most common cases), it depends on the selected ADO Provider.

After the preconfiguration is created, the "PmaAdo > ADO > Database connection parameters" configurator will be set to this value.

Creates the designer's methods of the interfaceCreate the main and auxilliary methods for working with database table
Type of database being connected
dBase
Microsoft Access
Microsoft SQL Server
SQL Server Compact
Oracle
MySQL
Firebird
Other database

History:
Pm8.01.00: Created
PROMOTIC 9.0.11 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