ODBC Client Driver OPC Server - KEPServerEX OPC Servers

Overview

Kepware's 32 bit ODBC Client driver works in conjunction with our OPC Server KEPServerEX, to provide single-point access to multiple ODBC data sources via ODBC (Open DataBase Connectivity). 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. Data integrity is ensured with our extensive error handling.

The ODBC OPC server will provide single-point management of multiple ODBC data sources through the power and speed of OPC.

Devices

Supported Devices

Databases:

Microsoft Access
Microsoft SQL
Oracle
Sybase
MySql

The ODBC Client Driver is capable of communicating with any application that supports the standard "ODBC" or MyODBC data source format.

Required: MDAC - Microsoft Data Access Components (it consists of several core components that provide various database technologies; including ODBC and its drivers.)

Features

Specific Driver Features

Specific

Clients may reside Locally or Remotely.
Clients can communicate via OPC or NetDDE.
Read and write access to multiple ODBC compliant databases.
Read and write to SQL engine.
Write to BIGINT stored procedure inputs.
Four access methods including fixed table, dynamic table, query, and stored procedure.
Auto tag generation based on tables, queries and stored procedures from your ODBC data source.
Auto-generation of SQL type 'NCHAR' as OPC type 'string'.
Simple and self-evident user interface will allow users to get their data immediately.

General

Multi-threaded design for optimum performance.
Application Connectivity
Device Connectivity for concurrent devices.
Supports running as a Windows NT Service.
Supports Direct Scaling of device data.
Full Time On-line operation.
CSV file import and exportof server tags.
User Management
Tag Management
Network Interface Selection
Channel Diagnostics provide real-time data.
OPC Diagnostics to view OPC events.
Modem support for all serial drivers.
OPC Quick Client application.
Visual Basic OPC Client with VB Examples.

OPC/DDE

OPC Data Access Version 1.0a
OPC Data Access Version 2.05a
OPC Data Access Version 3.0

Learn more about OPC - Open Process Control

HMI/Client

KEPServerEX has been enhanced to provide the widest range of connectivity of any server product available. KEPServerEX supports the following client server technologies:

FastDDE for Wonderware
SuiteLink for Wonderware
iFIX PDB for Intellution
DDE Format CF_Text
DDE Format AdvancedDDE

To see a list of HMI's and Clients that we support go to our HMI / Client Support page.

Required

Required Software and Hardware

Supported Operating Systems

Windows NT
Windows 2000
Windows Server 2003
Windows XP

PC Hardware

Minimum

400 Mhz Pentium CPU
128 Megs of RAM
100 Megs of Free Hard Drive Space

Recommended

600 Mhz Pentium CPU
512 Megs of RAM
100 Megs of Free Hard Drive Space

Hardware Requirements

For Device and Hardware Requirements see the Devices tab.
Hardware Accessories

Protocol

Communication Protocol

ODBC API - Open DataBase Connectivity Application Programming Interface

VB

Visual Basic

KEPServerEX Visual Basic OPC Client
Complex and Simple Visual Basic OPC Client Examples
Using Modems and Visual Basic with KEPServerEX.
Download the Modem and VB Example with Source Code
Knowledge Base

Help

Help/Links