ActiveXperts Network Monitor uses OLE DB (also known as ADO) to check availability of databases.
OLE DB (sometimes written as OLEDB or OLE-DB) is an API for accessing different types of data stores in a uniform manner,
including: MS SQL, MS Access, Oracle, MySQL and more.
A Database Query check requires the following parameters:
- OLE DB (ADO) Connection String - The OLE DB connection string, for instance:
DRIVER=Microsoft Access Driver(*.mdb);DBQ=\\SERVER03\Public\Northwind.mdb.
You can use a password in this connections string. To hide the password, you can use the <%PASSWORD%> placeholder. When using this placeholder, ActiveXperts will automatically substitute this placeholder with the 'Password' field described below;
- Password - This is the password string (shown as asterisks) that will substitute the <%PASSWORD%> field described above;
- Database Query - The database query. The result of the check is determined by the result of this query;
- Match Field - The field that will be matched to determine the result of the check;
- Type - Type of field to be checked;
- Field must be Equal To / Not Equal To / ... - Operator used to determine the result of the check;
|
