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.
The Database Query check takes the following parameters::
- OLE DB 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 - the password (only if logon to the database is required);
- Database Query - The database query. The result of the check is determined by the result of this query;
- Database Field - The field that will be matched to determine the result of the check;
- Field must be Equal To / Not Equal To / - Operator used to determine the result of the check.
|
|
