Versions Compared

Key

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

...

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

...

  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 boxwindow.
    Image Modified
  5. To create a new protocol database, click the OK button. 
  6. Shut down Microsoft SQL Server Management Studio Express by clicking the CloseImage Removed button in the upper right corner of the dialog boxwindow.

As a result, the protocol database is created.

...

  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.
    Image Modified
  3. To enable the Protocol database, set the Use checkbox (1).

    As a result, the Configure button becomes active (2).
  4. To connect to the the Protocol database, click the Configure button.As  As a result, the Data link properties dialog box window appears.
  5. Go to the the Provider tab.
  6. Select the Microsoft OLE DB Provider for SQL Server in from the OLE DB Provider(s) list (1).
    Image Modified
  7. Click the Next button (2).You  You will be automatically redirected to the Connection tab.
  8. Do the following in the Connection tab:
    1. Select a server name from the Select or enter a server name drop-down list (1).
      Image Modified
    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.
      Image Added
    5. In the Persist Security Info field, set the True value. This is necessary to correctly save the user password.
      Info
      titleNote

      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)list.

      Info
      titleNote

      You must select a database at this step. If you leave the database field blank, 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 is inactive.

    7. Click the Test connectionConnection 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 boxwindow. The box window closes automatically.

  9. Select the dbi file. Click the button next to the Select dbi-file information field.
  10. As a result, the Open dialog box window appears.
  11. Select the database structure file Cfile C:\Program Files\Axxon PSIM\psimprotocol.dbi.
  12. Click the Update database button to update to update the database in accordance with the intellectpsim.dbi file specified in the Select dbi-file field.

    As a result, database updating will startupdate starts. Information about this process is displayed in the the Protocol table.
    Database is updated, when there is the Database Updating is completed! message in the Protocol table.
  13. To save Axxon PSIM connection parameters to the Protocol database, click the OK button. As a result the dialog box window closes automatically.

External event protocol is created and connected.