ODBC, OLE DB application detailed

Odbc:

Basic concepts

According to the Baidu Encyclopedia, ODBC is an open database interconnect (open databases Connectivity) is an integral part of the database in the Microsoft Open Services architecture, which establishes a set of specifications and provides a standard API (application interface) for a set of age-old database accesses. ODBC itself also provides support for the SQL language, which allows users to send SQL statements directly to ODBC. Is Microsoft's proposed database access interface standard.

In a nutshell, ODBC is an open standard for connecting databases.

ODBC is the middleware between an application and a database system. It provides database independence by using the corresponding driver-to- application interaction on the appropriate application platform and the required database to operate on the database, avoiding the need to invoke database-related operations directly in the application.

Composition
ODBC is primarily composed of drivers and driver managers.

A driver is a module that supports ODBC function calls, and each driver corresponds to the corresponding database, and when an application is migrated from one database system to another, simply change the alias of the application that is set by the ODBC Administrator to the corresponding database system. The driver manager is linked to all ODBC applications and is responsible for managing the binding of ODBC functions in the application to functions in the DLL.

OLE DB:

Basic concepts:

As explained by the must-read Encyclopedia: OLE DB is a strategic, low-level application interface to different data sources for Microsoft.

OLE DB is located between the ODBC layer and the application. In your ASP page, ADO is an application that is located above OLE DB. Your ADO call is sent to OLE DB before being processed by ODBC. You can connect directly to the OLE DB layer, and if you do, you'll see a performance boost for server-side cursors (the default cursor for the recordset and the most common cursor).

To connect to a database with ODBC:

There are three types of DSNs available in ODBC, the difference is simple: the user DSN can only be used for this user. The difference between a System DSN and a file DSN is that the connection information is stored in a different location: The System DSN is stored in an ODBC storage area, and the file DSN is placed in a text file.

ODBC, OLE DB application detailed