Monitor Access Database File

StevenE · Post by **StevenE** » Thu Dec 22, 2005 3:31 pm

Hi,

We have an application that stores and errors or system related info in an access database. Rather than just an error log.

Can Host Monitor read the access database and monitor a particular field in this database looking for key words ?

Thanks
StevenE

KS-Soft · Post by **KS-Soft** » Thu Dec 22, 2005 4:22 pm

Sure, use ODBC Query test method

Regards
Alex

StevenE · Post by **StevenE** » Fri Dec 23, 2005 10:55 am

Maybe someone could help me, with the query. I am not that familiar with sql query's

I created a query for the table pendingTransmission and the field status. The test works fine as long as there are items in the database. when the Table is empty I get "inaccessable value" in Host-monitor and the test turns bad.

SELECT PendingTransmission.Status
FROM PendingTransmission
Where (((PendingTransmission.Status)>1));

Thanks for any help
StevenE

KS-Soft · Post by **KS-Soft** » Fri Dec 23, 2005 12:14 pm

So what the problem? You do not like Bad status? Then use "If field is unavailable, set status ..." option of the test. You may choose Bad, Unknown or Ok status

Regards
Alex

StevenE · Post by **StevenE** » Fri Dec 23, 2005 12:39 pm

I did select if field is unavilable set status to OK.

Except when the test runs it still is marked bad and the replay is inaccessible value.

Anything marked BAD is not good

StevenE

KS-Soft · Post by **KS-Soft** » Fri Dec 23, 2005 1:55 pm

What version of HostMonitor do you use?

Regards
Alex

StevenE · Post by **StevenE** » Fri Dec 23, 2005 3:12 pm

V 5.70 I just upgraded today.

KS-Soft · Post by **KS-Soft** » Sat Dec 24, 2005 3:58 pm

It was our mistake

Problem fixed, update available at www.ks-soft.net/download/hm571.zip

Regards
Alex

StevenE · Post by **StevenE** » Thu Dec 29, 2005 9:30 am

It is now working fine, Thanks

StevenE