Preconfiguration "Microsoft SQL server - connecting to the database by the PmaAdo object and table usage."
connecting to the database by the PmaAdo
object and table usage..
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: " / Database access / Microsoft SQL server"
This preconfiguration can be created in the object: PmaFolder
object is created including the configured interface for selected database type. The connection string is also preconfigured in the DbConnectionString
property in order to allow connection to selected database. This will need to be modified in some cases to meet the requirements for connecting to the database on the target computer..
The panel is preconfigured in order to allow creation of testing table (datatest
) with primary key in the cindex
column. The SQL statement for table creation is included in the PmgString
object in field DbExecute
and is activated by the "Run the SQL statement
" button. The INSERT INTO
button can be used for adding new record into the database table. The values of new record are generated randomly (in the Values
field) by the button with "arrow in a circle" symbol. The buttons UPDATE
can modify the record or delete it. The button with "arrow in a circle" symbol in this case displays the value that is in the marked row of the table in cindex
column. There is an info system in the bottom of the panel that indicates the result of performed operations..
These configurators can be set before the preconfiguration is created:
|The name of created object||Name 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.
|Database connection string||When working with file databases, it is necessary to modify the path to the file or data files folder (dBase) in the created connection string.|
|Object scripting language||Application object scripting language|
0 - vbscript
|Enable as Web component||Specifies whether this object has to be registered as a Web server component
After the preconfiguration is created, the "PmaPanel > Web server > Enable as Web component" configurator will be set to this value.
|PmaWeb object||Path in the tree of Pma objects to the object PmaWeb, PmaWebFolder or PmaWebLang where the registration is carried out.
Macro expression can be used for input (it is evaluated after starting the application).
After the preconfiguration is created, the "PmaPanel > Web server > PmaWeb object" configurator will be set to this value.