Wednesday, November 13, 2019
Useful Resources for Brilliant Manufacturing, Operational & Industrial Intelligence Technology Enthusiasts!

Automation, Control & Plant Intelligence - Articles, Analysis, Reviews, Interviews & Views

OPC - OLE (Object Linking and Embedding) for Process Control :: The Industrial Interoperability Standard

ODBC - ODBC Architecture (Multiple Tier)
Knowledge Base

Automation Media's recommended most important key terminologies you need to know if you work in Automation, Controls, Brilliant Manufacturing, Operational & Industrial Intelligence or IoT etc. ; regardless of any vendor(s) you are dealing (Allen Bradley, GE Fanuc, Siemens, Modicon, Mitsubishi, Omron, Automation Direct etc).

There are basically two types of ODBC architecture:

  • Single Tier ODBC drivers

  • Multiple Tier ODBC drivers



  • Single tier drivers, such as the Microsoft® Access® driver, often operate directly on a database file or files.

  • A single tier ODBC driver processes both ODBC calls and the actual SQL commands.

  • In most cases, a configuration using a single tier driver can be contained on just one computer.



  • Multiple tier drivers are more common, and are typically used with a remote database server such as Oracle® and SQL Server.

  • Multiple tier ODBC drivers process ODBC calls made by the application, but pass the actual SQL command to the database system.



  • Typical architecture of a Relational Database Server and an ODBC driver






    Free OPC Clients   /   Free OPC Servers   /   Free OPC Utilities


    OPC Foundation owns all OPC trademarks including the OPC logo used throughout this site. Most of information in OPC Knowledge Base is from OPC foundation.
    Free Automation Stuff This information made available on Automation Media, are provided "as is" without any representation or warranty, express or implied, of any kind, including, but not limited to, warranties of merchantability, noninfringement, or fitness for any particular purpose. Automation Meida makes no warranty or representation regarding, and does not endorse, any linked Web sites or the information appearing thereon or any of the products or services described thereon.