FTView SE Datalog to ODBC Database

[jkerekes]

I'm using FTView SE to datalog to SQL Server with an ODBC connection. IS there a method to signal when this connection is broken for any reason? I know the datalogger can be configured to store data locally when the connection is broken. But I want to add an alarm and indicator to a screen when this happens.

The Rockwell suggestion is to periodically query the diagnostic log. I was seeing if there is a slightly easier way to detect this issue. Thanks.

 

[sigmadelta]

You could periodically query using the statement "SELECT 1" and put the result in a tag, then check if the tag value is 1 or 0.

https://stackoverflow.com/questions/3668506/efficient-sql-test-query-or-validation-query-that-will-work-across-all-or-most

 

[jkerekes]

Thanks. Let me give that a try.