What is the relationship between ADO, ADO, and OLE DB, ODBC, I found this article when I look for MSDN, and the content is relatively simple, but it is clear, the first translation, the wrong place, please correct.
The Role of Ado in Microsoft Data Access
ADO role in Microsoft Data Access
The Microsoft Data Access Components (MDAC) provide data access that is independent of data stores, tools, and languages. It provides a high-level, easy-to-use interface, and a low-level, high-performance interface to practically any data store available. You can use this flexibility to integrate diverse data stores and use your choice of tools, applications, and platform services to create the right solutions for your needs. These technologies provide the basic framework for general-purpose data access in Microsoft? Windows? Operating Systems.
MDAC provides data accesses independent of data sources, tools, and languages. It provides an advanced, simple interface, and a low-level but efficient interface to access almost all available data sources. You can use the flexibility to integrate different data sources and combine the tools, applications, and platform services you choose to establish the correct solution for your needs. These techniques provide a multi-purpose data access framework for a Windows operating system.
There are three primary technologies in MDAC. ActiveX Data Objects (ADO) is a high-level, easy-to-use interface to OLE DB.OLE DB is a low-level, high-performance interface to a variety of data stores. ADO and OLE DB both can work with relational (tabular) and nonrelational (hierarchical or stream) data. Finally, Open Database Connectivity (ODBC) is another low-level, high-performance interface that is designed specifically for relational data stores.
There are three main technologies in MDAC, and Ado provides advanced and simple interfaces for OLE DB. OLE DB provides low-level but efficient interfaces for different data sources. Both ADO and OLE DB access to relationships (such as tables) and non-relational (hierarchy or streams). Finally, ODBC is another low but efficient interface designed to specifically facing relational data.
ADO provides a layer of abstraction between your client or middle-tier application and the low-level OLE DB interfaces. ADOuses a small set of Automation objects to provide a simple and efficient interface to OLE DB. This interface makes ADO the perfect choice for developers In Higher Level Languages, Such As Visual Basic and Even Vbscript, Want To Access DataWithout Having to Learn The Intricacies of Com and Ole Db.ado is provided between your client or intermediate application and the low OLE DB interface An abstract layer. ADO uses a small automation object set to provide a simple and efficient access to OLE DB interface. This interface makes ADO a preferred choice for advanced language users, such as Visual Basic and VBScript, which do not need to access data by learning complex COM and OLE DB knowledge.
