Contents - Index

ODBC

Advanced Network Monitor uses ODBC to check availability of a variety of databases. Most major database systems support ODBC, such as: Microsoft SQL Server, Microsoft Access, Microsoft Excel, Oracle, FoxPro, Paradox, SyBase, Informix, OpenIngres, InterBase, Progress, IBM LANDP, DB2 and AS/400.

You must configure ODBC (from the Control Panel on the server where Advanced Network Monitor is running on) before Advanced Network Monitor can check ODBC compliant databases.

An ODBC check takes the following parameters:
  • ODBC Data Source - the ODBC DSN (Data Source Name). This DSN entry must be configured on the server where the Advanced Network Monitor service is running;
  • User name  - credentials required to access the database;
  • Password - credentials required to access the database

    Advanced Network Monitor tries to connect to the ODBC server. If the connection was established successfully then the server is marked as "Success", otherwise it is marked as "Error".