Knowledge Center > FAQs

The ADO (SQL Connect) and ADO - QA (SQL Query) Monitors require that you have the correct OLE DB Provider installed on the ipMonitor host computer to provide access to the database type you wish to use.

To access a PostgreSQL Database, you will need to download and install the PostgreSQL OLE-DB Driver, available from PostgreSQL at http://www.postgresql.org/download/.

IMPORTANT! You'll require the following information before you begin:

• The Server Name or address of the machine where the PostgreSQL Database is located.
• The Database Name of the PostgreSQL Database instance you want to monitor.
• A username and password to access the PostgreSQL Database.

1. Extract the PGOLEDB.DLL and LIBPQ.DLL files from the "PgOleDb-1.x.x.x.zip" file into the WINDOWS\System directory (or WINNT\System\ on Win 2k machine).
2. Click the Windows Start button, and then click Run. Enter the following command into the Open field:
   
   regsvr32 PGOLEDB.DLL

3. Click OK, and then click OK a second time to close the "success" window.

4. Create a new text file on the ipMonitor host machine and rename it to PostgreSQL.udl. Double-click the file to open it.
5. Click the Provider tab and select PostgreSQL OLE DB Provider from the list.
6. Click the Connections tab, and then enter the Data Source, Location, User Name and Password required to connect to the PostgreSQL Database.

7. Click the Test Connection button to verify that you can access the PostgreSQL Database you wish to monitor.

For additional information regarding the ADO and ADO - QA Monitors, refer to the Monitors section of ipMonitor's Context-Sensitive Help system, and then select Monitor Types. The Context-Sensitive Help can be accessed by clicking the Help link located in the top right corner of ipMonitor's Add ministration web interface.

For information on other features and concepts related to those discussed in this article, refer to the following ipMonitor resources:

< Back

Last Updated: April 25, 2006 | What did you think of this topic?