Differences between ADO, OLEDB, ODBC, DAO, and RDO

ODBC (Open Database Connectivity and Open Database interconnection) is an integral part of the Database in Microsoft's WOSA (Windows Open Services Architecture). It establishes a set of specifications, it also provides a set of standard APIs for database access (application programming interfaces ). These APIs use SQL to complete most of their tasks. ODBC also provides support for the SQL language. You can directly send SQL statements to ODBC.

Ii. DAO: the data access object is used to expose the Microsoft Jet Database Engine (which was first used for Microsoft Access and now supports other databases) and allows developers to directly connect to other databases through ODBC, directly connect to the Access table. DAO is most suitable for single-system applications or local distribution in a small range. Its internal access to the Jet Database has been accelerated and optimized, and it is also very convenient to use. Therefore, if the database is an Access database and is used locally, we recommend that you use this Access method.

RDO (Remote Data Objects) Remote Data Objects are an ODBC-oriented Data access interface. They are combined with easy-to-use DAO styles and provide an interface, shows the underlying functions and flexibility of all ODBC databases. Although RDO is restricted in its access to Jet or ISAM databases, it can only access relational databases through the existing ODBC driver. However, RDO has proved to be the best interface that many SQL Server, Oracle, and other large relational database developers often choose. RDO provides more complex objects, attributes, and methods used to access stored procedures and complex result sets.

Ole db is a strategic system-level programming interface of Microsoft that is used to manage data within the entire organization. Ole db is an open specification built on the ODBC function. ODBC is specially developed to access relational databases. ole db is used to access relational and non-relational information sources, such as the host ISAM/VSAM and hierarchical database, email and file system storage, text, graphics, and geographic data, as well as custom business objects. Ole db defines a set of COM interfaces, encapsulates various database management system services, and allows you to create software components to implement these services. Ole db components include data providers (including and presenting data), data users (using data), and service components (processing and transmitting data, such as query processors and cursor engines ). Ole db interfaces help to smoothly integrate components, so that ole db Component vendors can quickly provide high-quality ole db components to the market. In addition, ole db contains a "bridge" Connecting ODBC, which provides consistent support for various ODBC relational database drivers.

ActiveXData Object is a successor of DAO/RDO. ADO2.0 is more similar in functionality to RDO, and generally there is a similar ing relationship between the two models. ADO "extends" the object model used by DAO and RDO, which means it contains fewer objects, more attributes, methods (and parameters), and events. As the latest database access mode, ADO is also easy to use, so Microsoft has clearly stated that it will focus on ADO in the future and will not upgrade DAO/RDO, therefore, ADO has become the mainstream of database development. ADO involves three Data Storage Methods: DSN (data source name), ODBC (open data connection), and OLEDB