Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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