ODBC, DAO, ADO, OLEDB database connection differences and contact

xiaoxiao2021-03-18  215

ODBC is a bottom-level access technology. Therefore, ODBC API can be a customer application that can set and control the database from the underlying layer, complete the function of unable to complete some advanced database technologies; but due to ODBC can only be used for relational databases, This makes it difficult to access object databases and other non-relational databases using ODBC.

DAO provides a mechanism for creating and manipulating databases through program code. The biggest feature is that the operation of the Microsoft Jet database is very convenient, and it is one of the best technology interfaces when operating the Jet database. And it doesn't only use access to access

This database, in fact, through DAO technology can access a variety of data formats such as text files to large background databases.

ADO is based on

OLE DB Access Interface, it is an object-oriented OLE DB technology, inherits the advantages of OLE DB. A high-level interface belonging to the database access.

-------------------------------------------------- ------------------------------

Access interface Easy to use sexual operation Performance Scalability Problem Can Access non-relational data source technology level

-------------------------------------------------- ------------------------------

ODBC differences can be subjected to underlying control No underlayer

-------------------------------------------------- ------------------------------

MFC ODBC is very general standard, widely used

-------------------------------------------------- ------------------------------

MFC DAO is highly general access JET performance is best high-level

-------------------------------------------------- ------------------------------

OLE DB is more difficult to access non-relational DB can be under

-------------------------------------------------- ------------------------------

ADO is best to access non-relationship, there are a variety of programming interfaces.

-------------------------------------------------- ------------------------------

Glossary::

l ODBC (Open Database Connectivity) Open Database Interconnection. It is the database linkage chain dominated by Microsoft.

L MFC (Microsoft Foundation Class) Microsoft Basics. The MFC ODBC is a package for ODBC.

l DAO (Data Access Object) Data Access Object. Remote access is not available.

l RDO (Remote Data Object) Remote data object. Fast, support the SQL Server stored procedure, which is the same as DAO.

l OLE-DB (Object Linking and Embedding Database) Object Links and embedded databases. It relies on COM and provides vendors for OLE DB providers rather than ODBC. l ADO (ActiveX Data Object) ActiveX data object. Local and remote database access technologies based on OLE-DB establishment. "Young" is to be "young" as OLE-DB.

In use, we generally replace DAO and RDO with OLE-DB and ADO.

In addition, the relationship between ADO and OLEDB is:

l OLEDB is a underlying data access interface interface. It is an application for a third-party driver business to develop output data originates to ADO-technology or developers developer developers developers developers customized.

l ADO is based on OLE DB access interface, which is an object-oriented OLE DB technology, inherits the advantages of OLE DB. A high-level interface belonging to the database access.

l OLE DB is an important system-level programming interface for accessing data, which is the basic technology of ADO, or is also the data source of ADO.NET.

l You can say that ADO provides high-level application API functions for OLEDB

转载请注明原文地址:https://www.9cbs.com/read-129980.html

New Post(0)