Differences and connections between ODBC, oledb, and ADO

ODBC is an underlying access technology. Therefore, ODBC APIs can be used by customer applications to set and control databases from the underlying layer to complete functions that cannot be completed by advanced database technologies; however, ODBC can only be used for relational databases, making it difficult to Use ODBC to access object databases and other non-relational databases.

Dao provides a mechanism for creating and manipulating databases through program code. The biggest feature is that it is convenient to operate the Microsoft Jet Database and is one of the best technical interfaces for operating the Jet Database. In addition, it is not only used to access such databases. In fact, DAO technology can be used to access various data formats, such as text files and large backend databases.

ADO is an access interface based on ole db. It is an object-oriented ole db Technology and inherits the advantages of ole db. It is a high-level interface for database access.

Oledb andODBCBoth underlying systems allow direct access to databases. The difference is that oledb can access both relational databases and non-relational databases, while ODBC can only access relational databases. Although the operations on different databases are different, the underlying application interfaces for different data sources are unified.

 

The relationship between ADO and oledb is:
Oledb is an interface for accessing underlying data. It is an application used by third-party drivers to develop and output data sources to ado-technology, or a database component developed and customized by C ++ developers.
ADO is an access interface based on ole db. It is an object-oriented ole db Technology and inherits the advantages of ole db. It is a high-level interface for database access.
Ole db is an important system-level programming interface used to access data. It is an ado
And the data source of ADO. net.
In this case, ADO provides high-level application API functions for oledb.

The following is a comparison of the performance:

Note:

ODBC (Open Database Connectivity) Open Database interconnection. It is a database connection Standard dominated by Microsoft.

Dao (Data Access Object) Data Access Object. Remote access is not provided.
ActiveX Data Object (ADO) ActiveX Data Object. Local and remote database access based on OLE-DB. Be "Younger" like OLE-DB. In use, we generally use OLE-DB and ADO to replace Dao and rdo.

OLE-DB (Object Linking and Embedding database) object link and embedded database. It depends on COM and the vendors that provide ole db providers, rather than the SQL statements used by ODBC.
MFC (Microsoft Foundation Class) Microsoft basic class. Mfc odbc is an encapsulation of ODBC.
Rdo (Remote Data Object) Remote Data Object. It is fast and supports SQL Server Stored Procedures. Like Dao, it has been developing for many years.