How to test or configure the ODBC connection for OnGuard

How to configure the ODBC connection for OnGuard

Procedure Steps

If you experience problems connecting to the OnGuard database, check the ODBC connection to be sure it is configured correctly.

1) On a 64 bit machine navigate to C:\Windows\SysWOW64 and open the odbcad32 application.  Note: on 32 bit systems odbcad32 is located in C:\Windows\System32

2) Select the System DSN tab.

3) Select the DSN used to connect to the OnGuard database from the listing window.

4) Click [Configure].

5) Verify that the name of the server is correct in the drop-down list. Click [Next].

6) Check that the correct method of authentication is selected and verify the credentials if using SQL Server authentication. Click [Next].

7) Verify that the Change the default database to check box is selected and the OnGuard database is selected in the drop-down list. Click [Next].

8) Click [Finish]. The ODBC Microsoft SQL Server Setup dialog box is displayed.

9) Click [Test Data Source]. A success message should be displayed.

10) Click [OK] to close each of the dialog boxes.

Applies To

OnGuard (All versions)
SQL Server (All versions)

Additional Information

None