Wednesday, October 23, 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 (Single 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.


  • ODBC architecture of Microsoft Access is simpler than the typical server architecture. The following figure illustrates the ODBC architecture of Access and other single tier ODBC drivers.





    There is no database server computer, client support layer, or network in the figure. The Access ODBC driver works directly on the database file. In this simplest configuration, the database file is located on the same computer as the application.

    By using Microsoft networking, Novell networks, and the like, the database file could be located on another computer just like any other shared file. In this way, an Access database could be shared among several computers and applications.



    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.