The external event viewer is created using the idb.exe utility.

If you use the Time and Attendance module in the system that is a part of the Access Manager module of the ACFA PSIM subsystem, use the RemoteProtocolConnector utility to extract the event viewer into an individual database—see WEB Report System PSIM. User Guide (the most recent version of this document is available in AxxonSoft documentation repository).

For the report system to operate, which is a part of the base Axxon PSIM, use the method of extracting the event viewer into an individual database that is described in this section using the idb.exe utility. In the report subsystem, which is a part of the base Axxon PSIM, you must configure the connection to such a database protocol.

First, you must create the protocol database using the MS SQL Server program. For this, do the following:

  1. Open Microsoft SQL Server Management Studio Express;
  2. Select Databases.
  3. Right-click and select New Database…
  4. In the New Database… window that opens, enter the name of the protocol database in the Database name line.
  5. To create the new protocol database, click the OK button. 
  6. Close Microsoft SQL Server Management Studio Express by clicking the X button in the upper right corner of the window.

As a result, the protocol database is created.

To connect the external event viewer, do the following:

  1. Open the idb.exe utility (see Starting and shutting down the idb.exe utility).
  2. In the Select data source: drop-down list, select the database for the Protocol administering.
  3. To enable the mode if using the Protocol database, set the Use checkbox.

    As a result, the  button becomes active.
  4. To configure the connection to the Protocol database, click the  button. As a result, the Data Link Properties dialog window is displayed on the screen.
  5. In the window that opens, go to the Provider tab.
  6. Select the Microsoft OLE DB Provider for SQL Server item from the OLE DB Provider(s) list.
  7. Click the Next button. You are automatically redirected to the Connection tab.
  8. Do the following in the Connection tab:
    1. From the 1. Select or enter a server name: drop-down list, select the server name. 
    2. In the User name field, specify the user name.
    3. In the Password field, enter the password.
    4. Set the Allow saving password checkbox.
    5. Go to the All tab.
    6. In the Persist Security Info field, set the True value. This is necessary to correctly save the user password.

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

    7. From the 3. Select the database on the server drop-down list, select the protocol database.

      You must select a database at this step. If you leave the database field blank, then after you close the Data Link Properties window, the line "Database is not set in connection settings" appears in the database description window of the idb.exe utility, and the OK button to save changes becomes inactive.

    8. Click the Test Connection button.

    9. If you successfully connect to the MS SQL server, the Test connection succeeded message is displayed.

    10. Click the OK button in the message window to close it.

  9. Click the Update database button to start the process of updating the database structure.
    As a result, the process of updating the database structure starts with the corresponding messages that are displayed in the Protocol table. 
    The structure is updated when the Data Updating is completed! message is displayed in the Protocol table.
  10. To save Axxon PSIM connection parameters to the Protocol database, click the OK button. As a result, the dialog window closes automatically.

Creating and connecting the external event viewer is complete.