Associated with: ODBC Connections, ODBC Queries
This attribute indicates the present state of the ODBC Connection or ODBC Query.
The attribute indicates whether there is a problem with the Connection or Query configuration in relation to the database that it is trying to access.
For an ODBC Connection, the possible states are: Online, Not In Service, Uninitialized, Failed
Where the state is ‘Uninitialized’, this indicates that the ODBC driver is not running. (Additionally, the Quality attribute will display the state ‘Device Failure’.)
Where the state is ‘Failed’, the attribute includes a description that indicates the reason for the failure. ClearSCADA receives the descriptions from the WindowsTM ODBC Navigator.
Failed - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
(This error indicates that the configured Data Source does not exist.)
For an ODBC Query, the possible states are: Online, Offline, Uninitialized, Failed
Where the state is ‘Offline’, use the State attribute in conjunction with the Quality attribute to assess the reason for the Query being offline (for example, the Quality attribute might indicate that the Query is not connected or is out of service).
Where the state is ‘Uninitialized’, this indicates that the ODBC driver is not running. Additionally, the Quality attribute will display the state ‘Device Failure’.
Where the state is ‘Failed’, the attribute includes a description that indicates the reason for the failure.