Created by Norsolihati Selamat, last modified by Rodim Suarez on Aug 31, 2016
Views: 441Votes: 0Revisions: 3
This article describes how to troubleshoot ADO monitors.
All IPMonitor versions
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
Select Provider, provide Connection information and click test option.
If test is successful, close Data Link Properties and open UDL file in notepad. Use connection string to populate ADO Monitor.
If test fails, it is recommended to seek assistance from your DBA or technical support for further investigation.