Monday, August 21, 2017 Useful Resources for Industrial Technology Enthusiasts!


..


ODBC - ODBC Architecture (Typical)

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







    Find more about    ODBC - ODBC Architecture (Typical)

    Top 20 Industry Tags (Viewed during Last Hour):

    FM (Frequency Modulation) ../ Point-to-Point ../ HART ../ FHSS (Frequency Hopping Spread Spectrum) ../ Demodulation ../ CTS (Clear to Send) ../ Store and Forward ../ GNU - What is GNU? ../ Half Channel ../ DOX (Data Operated Transmit) ../ kHz (Kilohertz) ../ Bit ../ Reflective Memory ../ GHz (Gigahertz) ../ PLC (Programmable Logic Controller) ../ Simplex ../ Thermocouple B-Type ../ OPC ../ Datablock or Poll Record ../ Host Computer, Host ../ See More..

    << Back




    ........

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