ODBC Client驱动 - Kepware OPC Server 中国区总代理、合作伙伴 - 上海泗博自动化技术有限公司

返回上一页

ODBC Client

产品概览

下载试用

ODBC Client 驱动与 KEPServerEX 协同工作，可通过 Open DataBase Connectivity (ODBC) 提供对多个 ODBC 数据源的单点访问。ODBC 的目标是能够从任何应用程序收集任何数据，而无论处理数据的数据库管理系统 (DBMS) 为何。利用 OPC 的功能和速度，KEPServerEX 能够向任何支持 OPC/DDE 的客户端提供 ODBC 数据，并通过强大的错误处理能力确保数据完整性。

搜索 KEPServerEX 产品

联系销售人员

询价或售前咨询

  • 电话：4006 139 938 / 021-5102 8348
  • 电子邮件：

资源

  • 性能
  • 协议
  • 支持的设备
  • 可用语言
  • 应用程序支持
  • 发行说明
  • 更多技术信息
  • 相关硬件产品
  • 特色套件

性能

  • 客户端可位于本地或远程
  • 客户端可通过 OPC 或 NetDDE 通信
  • 支持读取和写入访问多个 ODBC 合规数据库
  • 支持读取和写入 SQL 引擎
  • 写入 BIGINT 型存储程序输入
  • 支持四种访问方法，包括固定表、动态表、查询和存储程序
  • 支持从 ODBC 数据源基于表、查询和存储程序自动生成标签
  • 支持自动生成 SQL 类型“NCHAR”作为 OPC 类型“string”
  • 简单界面可使用户立即获取数据

协议

  • ODBC API

支持的设备

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

可用语言

  • 英语

应用程序支持

  • 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

发行说明

6.1.601.0

2017/4/4

  • 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

2017/3/20

  • 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

2015/10/20

  • 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

2014/10/21

  • 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

2014/2/18

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

5.13.191.0

2013/10/15

  • 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

2010/10/28

  • 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

2010/6/9

  • 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.
  • ODBC Client 驱动能够与支持标准“ODBC”或 MyODBC 数据源格式的任何应用程序通信。
  • 需安装 Microsoft Data Access Components (MDAC)。MDAC 包含若干核心组件，这些组件提供各种数据库技术，包括 ODBC 及其驱动。

相关硬件产品

工业以太网交换机

特色套件

什么是驱动？

KEPServerEX 不仅是 OPC 服务器，它还是一种适用于工业自动化和 IoT 的连接平台。只需下载 KEPServerEX，然后从包含 150 多种设备驱动、客户端驱动和高级插件的 Kepware 库中选择，以便适合您工业控制系统的独特通信要求。

驱动是一种软件组件，能够使 KEPServerEX 满足某个特定设备、系统或其他数据源的连接要求。此驱动处理 KEPServerEX 与数据源进行的所有专属通信；客户端接口处理通向监控或控制设备的应用程序的所有连接，包括支持的 OPC 连接、专属连接和开放式标准连接。

驱动可以单独或以套件形式获得授权许可。随着连接需求的发展，可以按需对其他驱动进行许可。

上海泗博自动化技术有限公司  Copyright(c) 2005-2021   SiboTech.net All Rights Reserved 
foot
公司总机： 021-6482 6558    |   沪ICP备15057390号