Product manual

76| Configuring monitor functions Manual
Screenshot 72 - MS SQL/ADO check parameters dialog
An MS SQL / ADO function requires the following parameters:
» ADO Connection String – Specify the ADO connection string which will be used to connect
to the SQL Server/Data source.
» Query – Specify the SQL Query which will be triggered when connection is established.
For more information on SQL/ADO connections strings, please visit
http://www.connectionstrings.com
4.7 Windows OS databases checks
4.7.1 Generic – ODBC
GFI Network Server Monitor makes use of ODBC to check for the availability of a variety of
databases. Major database systems that support ODBC include: Microsoft SQL Server, Microsoft
Access, Microsoft Excel, Oracle, FoxPro, Paradox, SyBase, Informix, OpenIngres, InterBase,
Progress, IBM LANDP, DB2 and AS/400.
To monitor a database via ODBC, you must first setup a System DSN entry to the
database you wish to monitor on the server running GFI Network Server Monitor.