Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Element name

Description

Default value

Allowed values

1

The Select data source drop-down list

A The drop-down list for selecting the database: local Configuration database, Events log database Event protocol database, or a remote database for synchronization

Basic data

Basic data – local Configuration database

Synchro source – remote database for synchronization

ProtocolEvent protocol database

Titles Captions Events log database

Other values are used when working with vertical solutions

2

The Description field

Information The information field that displays the description of the selected data source from the Select data source drop-down list

Intellect main database

"Intellect" main database – local Configuration database

Remote Synchro source – remote database for synchronization

"Intellect" system's external protocols database Event protocol database

Titles database Captions Events log database

Other values are not useddepend on the availability of the databases for the installed vertical solutions.

3

The Use checkbox

A The checkbox for enabling or disabling the selected database usage. When set, the Configure button becomes active, which is used for setting up the connection to the database

Checked

Checked – database is connected

Clear – database is not connected

4

The Move database button

The button used to transfer MS SQL Server database files (.mdf and .ldf) to the specified folder. The user should have the rights to create files in this folder. When the files are moved, the database is automatically attached.

Note. It is possible to move only the local DB (Basic data data source). When using a remote DB (Synchro sourse source data source), files can not be moved.

Active

Acttive Active – the idb.exe utility is connected to the MS SQL format database

Inactive – the idb.exe utility is not connected to the MS SQL format database

5

The Configure button

The button opens the Data Link Properties dialog box to configure the database connection. This button is active if the Use checkbox is set.

Active

Active – the idb.exe utility is connected to the database

Inactive – the idb.exe utility is not connected to the database


6

The Connection string information field

The information field displaying the summary about the database connection parameters


Depends on the database connection parameters, the server configuration or Remote Administrator's workplace workstation configuration 

Shows Displays the combination of the following parameters:

Provider, Integrated Security, Persist Security Info, Data Source.

The Provider parameter can take the following values:

  • SQLOLEDB.1 – when using the MS SQL server format database;
  • Microsoft.Jet.OLEDB.4.0 – when using the MS Access format server database

Other values are not used.

The Integrated Security parameter can take the following values:

  • SSPI – authentication on MS SQL server using Windows account information;
  • parameter not shown – authentication on MS SQL server using the user login/password, or using MS Access format database

The Persist Security Info parameter can take the following values:

  • True – allow saving the password for automatic connection to the database;
  • False – do not allow saving the password for automatic connection to the database

The Data Source parameter can take the following values:

  • the name of the MS SQL server used for managing the database;
  • the path to the .mdb file of the MS Access format database

7

Information field and the Select . dbi-file button

An The information field and a the button for selecting and displaying a the database structure file ( .dbi )file. The updated database will have the structure specified in this file.

C:\Program Files\Intellect\intellect.dbi

Full pathname of The full path to the .dbi file

8

Select .ddi file

Information field and the Select dbi-file button

The An information field and a the button for selecting and displaying the name of information about the .ddi file with system objects, events and actions.reactions

C:\Program Files\Intellect\Languages\ru\intellect.ddi

Full pathname of The full path to the .ddi dbi file

9

Convert MS Access to MS SQL database

A button for starting the conversion of an MS Access database to MS SQL format. This button is enabled if the utility is connected to an MS Access database.

Disabled

Enabled – idb.exe utility is connected to an MS SQL database

Disabled – idb.exe utility is not connected to an MS Access database

10

The Create backup copy (MS SQL) button

A The button for starting the process of creating a backup copy of the database. This button is enabled active if the idb.exe utility is connected to an the MS SQL format database.

EnabledActive

Enabled Active the idb.exe utility is connected to an the MS SQL format database

Disabled Inactive the idb.exe utility is not connected to an the MS SQL format database

1110

The Restore from backup (MS SQL) button

A The button for restoring the database from a previously created backup.

EnabledActive

Enabled Active the idb.exe utility is connected to an the MS SQL format database

Disabled Inactive the idb.exe utility is not connected to an the MS SQL format database

1211The Clear protocols checkbox

A The checkbox excluding that excludes the Event protocol log database while creating from the created database backup copy. It is recommended to set this checkbox if the size of the Event protocol log database is too large, and there is no need to include the Event protocol log in a the backup copy.

The setting is available only for the Intellect base database.

No

Yes Checked the database backup copy does not include the Event protocol log database.

No Clear – the database backup copy includes the Event protocol log database.

1312

The Update database button

A The button for starting the process of updating the database structure. The structure is updated according to the .dbi file specified in the Select . dbi File -file field.

EnabledActive

Enabled Active the idb.exe utility is connected to the configuration Configuration database

Disabled Inactive the idb.exe utility is not connected to the configuration Configuration database

1413

The Create dbi-file button

A The button for creating a database structure .dbi file (.dbi template).

EnabledActive

Enabled - Active – .dbi file creation is allowed.

1514

The Protocol information table

An information area displaying The information table that displays the progress of database processing: converting, structure updating, creating backup copy, etc.

Empty

An information area displaying Information messages about the progress of the database processing.

A The blue “i” marks the notifications about successful completion of each processing step.icon indicates that the processing step has been successfully completed

The A red “!” marks the notifications about icon indicates the errors in a the processing step.

A blue tick marks icon indicates the completion of the processing.

1615

The OK button

A The button for saving the database connection parameters and shutting - down the idb.exe utility.

EnabledActive

Enabled Active – saving database connection parameters and shutting - down the idb.exe utility is allowed.

Disabled Inactive – the utility is still processing the database.