Check out our online Database Monitoring Guidelines to read more about how to setup an MS SQL / ADO database check.
Network Monitor > Monitoring Databases
Q6750015: I have several SQL servers in my network, When monitoring an SQL server, I get the message "Unable to load Microsoft OLE DB libraries. MDAC 2.x or higher is required". Why is it?
ActiveXperts Network Monitor uses the OLE DB libraries to access SQL servers (and other ADO compliant databases). The OLE DB libraries are installed by most Operating System Service Packs and by many applications.
But if it is not installed yet, you can download it from the Microsoft website and install it. You can download the latest MDAC package from the Microsoft download site for free.
Network Monitor > Monitoring Databases
Q6750025: I can't get my ODBC check to work. What should I do?
First check your System DSN settings, and test them from the Control Panel. Be sure you are using the right DSN with Network Monitor. Or use ADO as an alternative; ADO works similar as ODBC but doesn't require DSN configuration.
Network Monitor > Monitoring Databases
Q6750030: I didn't get Oracle to work; after I re-installed the Oracle client and then Network Monitor, I got it to work; how come?
To monitor Oracle with ActiveXperts Network Monitor, it's recommended to install the ActiveXperts Network Monitor software on a working Oracle client. If you install it the other way around, you may run into problems, not getting Oracle monitoring to work.
Network Monitor > Monitoring Databases
Q6750033: I'm trying to monitor our Oracle database, but I can't figure out what the correct connection string is. Can you please assist?
There's no fixed connection string syntax for Oracle; the format of the connection string depends on the Oracle version, the authentication method and the type of security used. Please check the following web site for more information about Oracle connection strings: www.connectionstrings.com.
Network Monitor > Monitoring Databases
Q6750035: What databases are supported by the software?
There's native support for MS SQL and Oracle. Besides that, any ODBC and ADO compliant database is supported. To read more about ODBC, click here; to read more about ADO, click here.
Network Monitor > Monitoring Databases
| Error codes |
|---|
| Click here to view the full list of error codes |