Ado,oledb,odbc,dao,rdo Difference Description _ database Other

An ODBC (Open Database Connectivity) is an integral part of the database in Microsoft's Open service architecture (Wosa,windows Open Services Architecture), which establishes a set of specifications , and provides a set of standard APIs (application programming interfaces) for accessing the database. These APIs use SQL to accomplish most of their tasks. ODBC itself also provides support for SQL languages, and users can send SQL statements directly to ODBC.

Two DAO: Data Access objects are used to expose the Microsoft Jet database engine, which is used first to MicrosoftAccess, now supports other databases, and to allow developers to connect directly to Access tables, just as they can connect to other databases through ODBC. DAO works best for single system applications or for small-scale local distribution. Its internal access to the Jet database has been accelerated and optimized, and it is easy to use. So it is recommended to use this access if the database is an Access database and is used locally.

Three RDO (remote Data Objects) a remotely-oriented, object-oriented data access interface, combined with the Easy-to-use DAO style, provides an interface that formally shows the underlying functionality and flexibility of all ODBC. Although RDO is limited in terms of good access to Jet or ISAM databases, it can access relational databases only through an existing ODBC driver. However, RDO has proven to be the best interface that many SQL Server, Oracle, and other large relational database developers often choose. RDO provides more and more complex objects, properties, and methods for accessing stored procedures and complex result sets.

Four OLE DB is a strategic, system-level programming interface for Microsoft to manage data across the organization. OLE DB is an open specification built on ODBC functionality. ODBC is specifically developed for access to relational databases, and OLE DB is used to access relational and non relational sources of information, such as host Isam/vsam and hierarchical databases, e-mail and file system storage, text, graphics and geographic data, and custom business objects. OLE DB defines a set of COM interfaces, encapsulates various database management system services, and allows the creation of software components to implement these services. OLE DB components include data providers (including and presentation data), data consumers (using data), and service components (processing and transferring data, such as query processors and cursor engines). OLE DB interfaces help smooth integration of components so that OLE DB component vendors can quickly deliver high-quality OLE DB components to the marketplace. In addition, OLE DB contains a "bridge" connecting ODBC, providing consistent support for the various ODBC relational database drivers that are in use.

Five ADO (Activexdata Object) is the successor of Dao/rdo. ADO2.0 are functionally more similar to RDO, and generally there is a similar mapping between the two models. ADO "Extends" the object model used by DAO and RDO, which means that it contains fewer objects, more properties, methods (and parameters), and events. As the latest database access mode, ADO is also easy to use, so Microsoft has made it clear that the future focus on ADO, the Dao/rdo no longer to upgrade, so ADO has become the mainstream of the current database development. ADO involves data storage with DSN (data source name), ODBC (Open data Connection), and OLE DB three ways