ODBC Client

Product Overview

The ODBC Client driver provides single-point access to multiple ODBC data sources via Open DataBase Connectivity (ODBC). The goal of ODBC is to make it possible to gather any data from any application, regardless of which database management system (DBMS) is handling the data. Using the power and speed of OPC, Kepware is able to offer ODBC data to any OPC/DDE enabled client and ensures data integrity through extensive error handling.

• Clients may reside Locally or Remotely
• Clients can communicate via OPC
• Supports read and write access to multiple ODBC-compliant databases
• Supports read and write to SQL engine
• Write to BIGINT stored procedure inputs
• Supports four access methods, including fixed table, dynamic table, query, and stored procedure
• Supports automatic tag generation based on tables, queries, and stored procedures from your ODBC data source
• Supports automatic generation of SQL type 'NCHAR' as OPC type 'string'
• Simple interface enables users to get their data immediately

• ODBC API

• Microsoft Access
• Microsoft SQL
• MySql
• Oracle
• Sybase

• English

• DDE Format CF_Text and AdvancedDDE
• NIO Interface for iFIX
• OPC .NET Service (OPC .NET) Version 1.00
• OPC Alarms and Events (OPC AE) Version 1.10
• OPC Data Access (OPC DA) Versions 1.0a, 2.0, 2.05a, and 3.0
• OPC Unified Architecture (OPC UA) Clients
• SuiteLink and FastDDE for Wonderware

• ODBC Client Manual

Access and search all Kepware product release notes here.

• The ODBC Client driver is capable of communicating with many applications that support the standard "ODBC" or MyODBC data source format.
• Microsoft Data Access Components (MDAC) is required. MDAC consists of several core components that provide various database technologies; including ODBC and its drivers.

• Manufacturing Suite