(mysql.info.gz) MyODBC Architecture

Info Catalog

(mysql.info.gz) Introduction to ODBC

(mysql.info.gz) MyODBC General Information

(mysql.info.gz) Driver Manager

 
 23.1.2.2 MyODBC Architecture
 ............................
 
 The MyODBC architecture is based on five components, as shown in the
 following diagram:
 
 [image src="Images/myarchitecture.png" text=""]
 *Application:*
      An application is a program that calls the ODBC API to access the
      data from the MySQL server. The Application communicates with the
      Driver Manager using the standard ODBC calls.  The Application
      does not care where the data is stored, how it is stored, or even
      how the system is configured to access the data.  It needs to know
      only the Data Source Name (DSN).
 
      A number of tasks are common to all applications, no matter how
      they use ODBC.  These tasks are:
         * Selecting the MySQL server and connecting to it
 
         * Submitting SQL statements for execution
 
         * Retrieving results (if any)
 
         * Processing errors
 
         * Committing or rolling back the transaction enclosing the SQL
           statement
 
         * Disconnecting from the MySQL server
 
      Because most data access work is done with SQL, the primary tasks
      for applications that use ODBC are submitting SQL statements and
      retrieving any results generated by those statements.
 
 *Driver manager:*
      The Driver Manager is a library that manages communication between
      application and driver or drivers. It performs the following tasks:
 
         * Resolves Data Source Names (DSN)
 
         * Driver loading and unloading
 
         * Processes ODBC function calls or passes them to the driver
 
 *MyODBC Driver:*
      The MyODBC driver is a library that implements the functions in the
      ODBC API. It processes ODBC function calls, submits SQL requests
      to MySQL server, and returns results back to the application. If
      necessary, the driver modifies an application's request so that
      the request conforms to syntax supported by the MySQL.
 
 *ODBC.INI:*
      `ODBC.INI' is the ODBC configuration file that stores the driver
      and database information required to connect to the server. It is
      used by the Driver Manager to determine which driver to be loaded
      using the Data Source Name.  The driver uses this to read
      connection parameters based on the DSN specified.  For more
      information,  MyODBC Configuration.
 
 *MySQL Server:*
      The MySQL server is the source of data. MySQL is:
 
         * A database management system (DBMS)
 
         * A relational database management system (RDBMS)
 
         * Open Source Software
 
 

Info Catalog

(mysql.info.gz) Introduction to ODBC

(mysql.info.gz) MyODBC General Information

(mysql.info.gz) Driver Manager