SQL - ADO monitor

The SQL - ADO Monitor verifies that:

  • You can log in to an SQL database server or another supported data source
  • Ample connection handles are available
  • The specified account can log in to the database

Microsoft® ActiveX® Data Objects (ADO) provide a set of advanced database abstraction classes used by applications to access and interact with data from a variety of sources through an installed OLE database provider.

The ADO Monitor wizard helps you configure an ADO monitor with the least amount of initial input by testing all the parameters you enter along the way. This process ensures that the monitor functions as expected before you move to a production environment.

If you install TLS 1.2 on the target device and the ADO monitor does not function properly after the update, see this KB article.

OLE DB provider requirements

The ADO monitor requires a supported OLE DB provider is installed to provide access to the database type you wish to use. The following database types are supported:

  • Microsoft SQL Server
  • Sybase SQL Server
  • IBM DB2
  • IBM Informix
  • PostgreSQL
  • Oracle
  • MySQL
  • Other

Use the Other database type option to manually configure the ADO monitor and test other data sources, such as SAP DB, FrontBase, FoxPro, and LDAP.

Providers have different implementation requirements and guidelines. SolarWinds recommends consulting the documentation provided by the appropriate third-party vendors before you install the OLE DB providers.

Verify your OLE DB provider

ipMonitor includes a Universal Data Link file that launches the Windows Data Link Properties dialog box to test connections between the ipMonitor host computer and OLE DB data sources.

The following example procedure shows how to verify that the SQL Server OLE DB provider is properly installed on the ipMonitor host machine and connectivity to the SQL Server can be established:

  1. Double-click the ipm7adotest.udl file located in the \ipMonitor root directory.
  2. In the Provider tab, select the correct OLE DB provider. If the required provider does not appear in the list, install the provider to enable ipMonitor to connect.
  3. In the Connection tab, select the SQL Server instance and enter the login and database information.
  4. Click Test Connection. If the test is successful, a Test Connection succeeded message is displayed.
  5. Click OK to save the settings.