Skip to main content

Connector

image2.png

Primary Database

  1. This setting defines the connection to the SQL Server database where WIN-911 alarms are logged. Use the browse pushbutton […] provided to connect.

    image3.png

  2. By default, the Server name is configured to the WIN911 instance on the local machine, using Windows Authentication to the LOG database named after the local machine.

  3. Click Test Connection to verify connectivity and return to the main dialog.

Settings

  • The Settings button opens the Settings dialog that defines characteristics of the database that are used to retrieve data.

    image4.png

  • Typically, these settings are defaulted correctly based on SQL Server.

  • If queries timeout, increase the Client Wait Time.

  • The Delimiter and Timestamp settings are typically filled in automatically for the database and can be modified for other databases.

  • The Date/Time Storage settings define how timestamps are stored in the database. Using this setting the timestamps are manipulated when data is retrieved so that local timestamps are submitted in and returned.

  • Many databases require the Date format to be YYYY-MM-DD so that no interpretation needs to occur based on the Region settings of the Windows Operating System. It is recommended to always have this option checked.

In this section: