Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > ipMonitor > Troubleshoot ADO monitors

Troubleshoot ADO monitors

Table of contents
Created by Norsolihati Selamat, last modified by Rodim Suarez on Aug 31, 2016

Views: 9 Votes: 0 Revisions: 3

Overview

This article describes how to troubleshoot ADO monitors.

Environment

All IPMonitor versions

Steps

  1. To test connectivity and authentication to an SQL server (MS SQL, Oracle, MySQL, etc), create a UDL file on the ipMonitor host.
    Note: If a 64-bit OS, UDL file must be started using 32-bit ODBC. To do this, use following command: C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl
  2. Select Provider, provide Connection information and click test option.
  3. If test is successful, close Data Link Properties and open UDL file in notepad. Use connection string to populate ADO Monitor.
  4. If test fails, it is recommended to seek assistance from your DBA or technical support for further investigation.

 

Last modified
22:03, 30 Aug 2016

Tags

Classifications

Public