Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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: 21 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

Tags

Classifications

Public