ODBC is a standard programming interface for accessing database management systems. Since its first publication in the 1980s, ODBC has been widely adopted.
The Fernhill SCADA ODBC Client driver acts as an ODBC client application. Using the driver you can:
The SQL Query can be executed at a fixed interval, or on demand, or both.
The Fernhill SCADA ODBC Client driver provides these tag types:
| Icon | Tag Type | Version | Description |
|---|---|---|---|
| ODBC Client Query Tag | 1.2 | An SQL query executed on an external ODBC data source. |
The ODBC Client Driver is a read-only driver.
You can use these I/O Data Point Tags to represent individual data points in the ODBC Query:
| Icon | Tag Type | Version | Description |
|---|---|---|---|
 | I/O Analog Data Point Tag | 3.12 | Maps an Analog Data Point Tag to an external data source. |
 | I/O Digital Data Point Tag | 3.12 | Maps a Digital Data Point Tag to an external data source. |
 | I/O String Data Point Tag | 3.12 | Maps a String Data Point Tag to an external data source. |
 | I/O Word Data Point Tag | 3.12 | Maps a 16-bit Word Data Point Tag to an external data source. |
 | I/O Double Word Data Point Tag | 3.12 | Maps a 32-bit Double Word Data Point Tag to an external data source. |
 | I/O Long Word Data Point Tag | 3.48 | Maps a 64-bit Long Word Data Point Tag to an external data source. |
To maximize interoperability, the ODBC Client Driver uses a minimal subset of the ODBC API functions:
| Feature | Functions |
|---|---|
| Manage handles | SQLAllocHandle, SQLFreeHandle |
| Manage connections | SQLDriverConnect, SQLDisconnect |
| Access result set metadata | SQLColAttribute, SQLNumResultCols |
| Prepare and execute statements | SQLBindParameter SQLExecDirect |
| Fetch result set rows | SQLFetch |
| Retrieve column data | SQLGetData |
| Get and set attributes | SQLSetEnvAttr |
| Obtain diagnostic information | SQLGetDiagRec |
For information about other drivers available in Fernhill SCADA.
For the meaning of terms used in Fernhill SCADA.