Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page Working with idb.exe utility with the use of keys  Creating the database backup copy Next page


External event protocol is created with the help of the idb.exe utility.

Attention!

If Time and Attendance module is in use (the module is a part of ACFA Intellect subsystem) use the RemoteProtocolConnector utility to extract event protocol into a separate database – see Intellect Web Report System. User Guide (the most recent version of this document is available in AxxonSoft documentation repository).

Note

To operate the Report System, which is a part of base Intellect, the method of extracting the event protocol into a separate database is used. The method is described in this section, i.e. using the idb.exe utility. Configuration of the connection to such protocol DB is required in the Report System, which is a part of base Intellect (see Connecting to the Events Log (PROTOCOL table)).

It is necessary to create the protocol database beforehand with the help of the MS SQL Server program. Do the following:

  1. Open Microsoft SQL Server Management Studio Express.
  2. Select Databases.
  3. Right-click and select New Database…
  4. Specify the protocol database name in the Database name line in the New Database dialog box.
  5. To create a new protocol database, click the OK button. 
  6. Shut down Microsoft SQL Server Management Studio Express by clicking the Close button in the upper right corner of the dialog box.

As a result, the protocol database is created.

To enable the external event protocol, do the following:

  1. Run the idb.exe utility (see Running and shutting down the utility).
  2. Select the Protocol database from the Select source database drop-down list.
  3. To enable the Protocol database, set the Use checkbox (1).
  4. As a result, the Configure button becomes active (2). To connect to the Protocol database, click the Configure button.
  5. As a result, the Data link properties dialog box appears. Go to the Provider tab.
  6. Select the Microsoft OLE DB Provider for SQL Server from the OLE DB Provider(s) list (1).
  7. Click the Next button (2).
  8. You will be automatically redirected to the Connection tab.
  9. Do the following in the Connection tab:
    1. Select a server name from the Select or enter a server name drop-down list (1).
    2. Specify the user name in the User name field and specify the password in the Password field (2).
    3. Set the Allow saving password checkbox (3).
    4. Go to the All tab.
    5. In the Persist Security Info field, set the True value. This is necessary to correctly save the user password.

      Note

      Each time you change the server connection parameters, you must set the Persist Security Info field value to True.

    6. Select the protocol database in the Select the database on the server drop-down list (4).

    7. Click the Test connection button (5).

    8. If the connection to MS SQL Server is successfully established, then the Test connection succeeded message appears.

    9. Click the OK button in the message box. The box closes automatically.

  10. Select the dbi file. Click the button next to the Select dbi-file information field.
  11. As a result, the Open dialog box appears.
  12. Select the database structure file – C:\Program Files\Intellect\intellect.dbi.
  13. Click the Update database button to update the database in accordance with the intellect.dbi file specified in the Select dbi-file field.
  14. As a result, database updating will start. Information about this process is displayed in the Protocol table.
  15. Database is updated, when there is the Database Updating is completed! message in the Protocol table.
  16. To save Intellect connection parameters to the Protocol database, click the OK button. As a result, the dialog box closes automatically.

External event protocol is created and connected.

  • No labels