Follow

How to configure ODBC DSNs in 32-bit and 64-bit versions of Microsoft Windows?

Answer

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

For a system running a 32-bit version of Microsoft Windows, perform the following procedure to access the ODBC administration application:

  1. From Administrative Tools in Windows, open Data Sources (ODBC). The ODBC Data Source Administrator window is displayed.
  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 shown.
  9. Click [Test Data Source]. A success message should be shown.
  10. Click [OK] to close each of the dialog boxes.

For a system running a 64-bit version of Microsoft Windows, perform the following procedure to access the ODBC administration application:

  1. From the search bar field in Windows, type C:\Windows\SysWOW64\odbcad32.exe and press ‘Enter’. The ODBC Data Source Administrator window opens.
  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 shown.
  9. Click [Test Data Source]. A success message should be shown.
  10. Click [OK] to close each of the dialog boxes.
 

Applies To

Basis/OnGuard (all versions)
Microsoft Windows (32-bit & 64-bit)

 

Additional Information

*This should be the same name as found in the ACS.ini file, under the following section:
[DataBase]
Connect="ODBC;DSN=Lenel"

Note: It does not matter what the DSN name is, but it must match in both the ACS.ini file and the data source name in the ODBC configuration.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Limited Warranty on Information: The documents contained on this website are distributed as is, without warranty of any kind, either express or implied, including but not limited to implied warranties for the document’s quality, performance, merchantability, or fitness for any particular purpose. Neither Stanley Security Solutions, Inc., nor its dealers or distributors shall be liable to the user or any other person or entity with respect to any liability, loss, nor damage caused or alleged to be caused directly or indirectly by this information.