ODBC Architecture

The ODBC driver fits in as a layer of “middleware” in the ODBC architecture, which includes the following components:

Application

An ODBC application is any program that calls ODBC functions and uses them to issue SQL statements. Many vendors have added ODBC support to their existing Windows-based tools so those tools can use ODBC for data access.

ODBC Driver Manager

On Windows platforms, the ODBC driver manager is a Microsoft-supplied dynamic-link library (DLL). On UNIX platforms, the ODBC driver manager is avendor-supplied shared library. The driver manager routes calls  from an application to the ODBC driver. To an application, the ODBC driver manager and the driver are a single entity that processes requests to the database. The ODBC driver manager loads the requested driver in response to an application’s call to the  ODBC SQLConnect or SQLDriverConnect functions.

ODBC Driver

An ODBC driver is a dynamic link library (DLL) or a shared library that processes ODBC function calls for a specific data source. The driver connects to the data source, translates the standard SQL statements into syntax the data source can process, and returns data to the application. There are ODBC drivers for every major database system.

Data Source

A data source is a combination of a database system, the operating system it uses, and any network software required to access it. ODBC defines a database system (DBMS) as any vendor’s implementation of a data access system that provides an SQL interface.

Advertisements
Posted in ODBC. 1 Comment »

One Response to “ODBC Architecture”

  1. durga prasad Says:

    ya it is explained well. It can be more understandable if u give the flow of operation in ODBC architecture.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: