ODBC Client Driver

Help Contents

Introduction

ODBC (Open Database Connectivity) 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.

Fernhill SCADA ODBC Client Driver Tags

The Fernhill SCADA ODBC Client driver provides these tag types:

Icon Tag Type Version Description
Query Tag 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.

Fernhill SCADA I/O Data Point Tags

You can use these I/O Data Point Tags to represent individual data points in the ODBC Query:

Icon Tag Type Version Description
Analog Data Point Tag I/O Analog Data Point Tag 3.12 Maps an Analog Data Point Tag to an external data source.
Digital Data Point Tag I/O Digital Data Point Tag 3.12 Maps a Digital Data Point Tag to an external data source.
String Data Point Tag I/O String Data Point Tag 3.12 Maps a String Data Point Tag to an external data source.
Word Data Point Tag I/O Word Data Point Tag 3.12 Maps a Word Data Point Tag to an external data source.
Double Word Data Point Tag I/O Double Word Data Point Tag 3.12 Maps a Double Word Data Point Tag to an external data source.

ODBC API Functions

To maximize interoperability, the ODBC Client Driver uses a minimal subset of the ODBC API functions:

FeatureFunctions
Manage handlesSQLAllocHandle,
SQLFreeHandle
Manage connectionsSQLDriverConnect,
SQLDisconnect
Access result set metadataSQLColAttribute,
SQLNumResultCols
Prepare and execute statementsSQLBindParameter
SQLExecDirect
Fetch result set rowsSQLFetch
Retrieve column dataSQLGetData
Get and set attributesSQLSetEnvAttr
Obtain diagnostic informationSQLGetDiagRec

Further Information

Fernhill SCADA Drivers

For information about other drivers available in Fernhill SCADA.

Glossary

For the meaning of terms used in Fernhill SCADA.