Friday, May 24, 2019 Useful Resources for Industrial Technology Enthusiasts!


ODBC - ODBC Architecture (Single Tier)

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.

    Find more about    ODBC - ODBC Architecture (Single Tier)

    Top 20 Industry Tags (Viewed during Last Hour):

    Packet ../ Point-to-Point ../ Repeater ../ Refarming ../ Portlets ../ BPS ../ Duplexer ../ CRC ../ PLC (Programmable Logic Controller) ../ Demodulation ../ Bandwidth ../ VHF (Very High Frequency) ../ VSTO - What is it? ../ Array ../ Bit ../ FM (Frequency Modulation) ../ DCE (Data Communication Equipment) ../ Multi-Path Fading ../ Half Duplex ../ Response Time ../ See More..

    << Back


    Site customized for Screen Resolution - 1400 x 1050
    Site Map    I    Copyright © 2019 Automation Media. All rights reserved.