Contents - Index

ODBC SQL

Advanced Network Monitor allows you to connect to ODBC SQL server and execute a user query. Depending on the query result and conditions you specified the program marks the server as "Success" or "Error".

The check takes the following options:
  • 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
  • Script source - enter you SQL query in this filed.
  • Also you need enter the conditions depending on the server is marked as "Success" or "Error":
  • First row in first record must be - Specify a comparison condition: "Equal to", "Less than", "Greater than", "NULL", "Not NULL".
  • to the following value - Enter a value the first row in the first record of the SQL query result will be compare with.

    Advanced Network Monitor tries to connect to the ODBC SQL Server and execute the specified SQL query (the SELECT command). If the query is executed successfully the program compares the first row in the first record of the SQL query result with the value you specified in the "to the following value" option. If the SQL query result meets the conditions the server is marked as "Success", otherwise as "Error".