Reconnecting to the ODBC Server

About this task

The ODBC collector supports auto-reconnect to the ODBC Server. If the connectivity between the ODBC server and the collector is down due to network connectivity issues, the collector will auto-reconnect to the server when the server is back and running. The collector polls for the server connection for a set time of every 5 seconds. The collector shuts down when the reconnect functionality is disabled.

To enable Auto-Reconnect to the ODBC Server:

Procedure

  1. From the Start menu, select Run and type Regedit, then, select OK.
    The Registry Editor appears.
  2. Open the key folder: HKEY_LOCAL_MACHINE\SOFTWARE\GE Digital\iHistorian\Services\ ODBCCollector.
  3. Create a new DWORD labelled, EnableReconnect.
  4. Enter the decimal value 1.
  5. Select OK, then close the Registry Editor.
  6. Restart the ODBC collector for the change to take effect.
    Important: If this registry is not created and set to a value of 1, then the auto-reconnect functionality will not be enabled.
    To configure the timer:
    1. From the Start menu, select Run and type Regedit. Then, select OK. The Registry Editor appears.
    2. Open the key folder: HKEY_LOCAL_MACHINE\SOFTWARE\GE Digital\iHistorian\Services\ ODBCCollector.
    3. Create a new DWORD labelled, ReconnectInterval.
    4. Enter a decimal value greater than 5. This value represents the number of seconds for the collector to wait before trying to re-connect to the ODBC Server.
    5. Select OK, and then edit the Registry Editor. Min Value = 5 seconds (default) Max Value = 60 seconds
    6. Select OK, and then edit the Registry Editor.
    7. Restart the ODBC for the change to take effect.