Go to documentation repository

Page tree

Documentation for Intellect 4.10.4. 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


Skip to end of metadata
Go to start of metadata

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

Important!

If Time&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 relevant version of this document is available in AxxonSoft documentation repository).

Note.

The way of extracting event protocol into an individual database described in this section, i.e. with the idb.exe utility, is the way to be used for Report System being part of the base Intellect software. Additional configuration of the connection to such protocol DB is required in Report System being part of the base Intellect software (see Connecting to the Events Log (PROTOCOL table)).

 The protocol database is to be created beforehand with the help of  MS SQL Server program. For this:

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

As a result the protocol database is created.

To enable external event protocol, do the following:

  1. Run the idb.exe utility (see Running and shutting-down the utility section).
  2. Select the Protocol administration database in the Select source database: dropdown list.
  3. To enable the Protocol database, set the Use checkbox (1).
  4. As a result the Build button becomes active (2). To connect to the Protocol database, click the Build 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 item in the OLE DB Provider(s) list (1).
  7. Click the Next button (2).
  8. There is an auto switch to the Connection tab.
  9. Do the following in the Connection tab:
    1. Select a server name in the Select or enter a server name dropdown 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. Select the protocol database in the Select the database on the server dropdown list  (4).

    5. Click the Test connection button (5)

    6.  If connection to MS SQL server succeded, then the Test connection succeeded message appears.

    7. 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 box appears.
  12.  Select the C:\Program Files\Intellect\intellect.dbi  file
  13. To update the database in accordance with the intellect.dbi file specified in the Select dbi file field, click the Update database button.
  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 finished message in the Protocol table.
  16. To save INTELLECT™ connection parameters to the Protocol database, click the OK button. As a result the box closes automatically.

External event protocol is created and enabled.

  • No labels