Loading...

ODBC Client

Licensing starts at $452.00
odbc client demo download

Product Overview

The ODBC Client driver works in conjunction with KEPServerEX to provide 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, KEPServerEX is able to offer ODBC data to any OPC/DDE enabled client and ensures data integrity through extensive error handling.

Resources

Performance

  • Clients may reside Locally or Remotely
  • Clients can communicate via OPC or NetDDE
  • 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

Protocols

  • ODBC API

Supported Devices

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

Available Languages

  • English

Application Support

  • 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) Version 1.02
  • SuiteLink and FastDDE for Wonderware

Release Notes

6.1.601.0

4/4/2017

  • Fixed a bug where MySQL stored procedures fail to execute.
  • Fixed an issue where millisecond resolution for DATETIME input types is lost when executing a stored procedure.

5.21.114.0

3/20/2017

  • Resolved an issue where MySQL stored procedures failed to execute. The issue was mistakenly introduced with the enhancements made in the 5.19 release.

5.19.467.0

10/20/2015

  • Added support for "Execute" statements within the Query access method.
  • Added an Execute tag for executing queries (e.g. Channel.Device.Execute).
  • Added the ability to enable or disable the query time interval. This allows users to exclusively trigger queries on demand via the device’s Execute tag.
  • Resolved an issue where a change in the query interval setting did not persist through shutdown and restart.
  • Removed duplicate messages that occurred in the event log when automatically generating tags.
  • Resolved issue with handling “money” and “smallmoney” data types as parameters to stored procedures in the stored procedure access methods.
  • Resolved an issue with the Update Tags button on the query and stored procedure access methods.
  • Resolved a configuration issue where a device prevents editing and reports that it is processing tags when no client references to the device exist.

5.16.722.0

10/21/2014

  • Increased the maximum number of channels from 100 to 256.
  • Updated the driver so that it will not force the access of tags added manually to be Read Only when the Set write access for imported database tags option is unchecked. This option only applies during automatic tag generation.
  • Updated automatic tag generation to force the internal tags that should be Read Only to be Read Only.

5.14.491.0

2/18/2014

  • Fixed an issue with incorrect Boolean conversion handling. Booleans can now be set and cleared properly.

5.13.191.0

10/15/2013

  • Fixed an issue where certain queries would result in bad quality for all tags in the device. The driver would post the "Unable to open recordset on device (Reason: Query timeout expired)" error message in the Event Log. This issue was due to an unnecessary query being used to count the number of items in the table.

5.4.131.0

10/28/2010

  • Fixed an issue with queries wherein the driver failed to read tags if the query included a UNION.
  • The EnableMiscellaneousQuerySettings registry setting was broken in 5x due to the separation of the Runtime and Configuration. The registry setting was removed, and the dialog page made visible to all users. A related wizard page was also added.

5.3.118.0

6/9/2010

  • Fixed an issue where the time stamps from reads of Oracle 10g failed because the returned string includes microsecond resolution. We now truncate the string to place it in a known format.
  • The ODBC Client driver is capable of communicating with any application that supports 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.

Featured Suites


What Is a Driver?

KEPServerEX is more than an OPC server—it's a connectivity platform for industrial automation and IoT. Simply download KEPServerEX, and then select from Kepware's library of more than 150 device drivers, client drivers, and advanced plug-ins to fit the communication requirements unique to your industrial control system.

A driver is a software component that enables KEPServerEX to meet the connectivity requirements of a specific device, system, or other data source. The driver handles all proprietary communications to the data source for KEPServerEX; the client interfaces handle all supported OPC, proprietary, and open standards connectivity to applications that monitor or control the devices.

Drivers may be licensed individually or in suites. Additional drivers can be licensed on demand as connectivity needs evolve.

Purchasing Information

ODBC Client

Subscription

Pay an annual fee to use the software. Support & Maintenance is included.

$452.00/yr.

© PTC Inc. All Rights Reserved.