ODBC Client Driver

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 execute an SQL query on an external database (provided the database supports ODBC) and map tags to specified positions in the result set. Queries 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 IO Data Tags

You can use these IO Data Tags to represent individual data points in the ODBC Query:

Icon Tag Type Version Description
Analog Data Tag IO Analog Data Tag 3.12 Maps an analog tag to an external data source.
Digital Data Tag IO Digital Data Tag 3.12 Maps a digital tag to an external data source.
String Data Tag IO String Data Tag 3.12 Maps a string tag to an external data source.
Word Data Tag IO Word Tag 3.12 Maps a 16-bit unsigned integer tag to an external data source.
Double Word Data Tag IO Double Word Tag 3.12 Maps a 32-bit unsigned integer 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 statementsSQLExecDirect
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.