Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the differences between ADO,OLEDB,ODBC,DAO,RDO". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

ODBC (Open Database Connectivity, Open Database Interconnection) is a part of the database in Microsoft's Open Service Architecture (WOSA,Windows Open Services Architecture). It establishes a set of specifications and provides a set of standard API (application programming interface) to access the database. These API use SQL to accomplish most of their tasks. ODBC itself also provides support for the SQL language, and users can send SQL statements directly to ODBC.

Second DAO: the data access object is used to expose the Microsoft Jet database engine (originally used by MicrosoftAccess, but now supports other databases), and allows developers to connect directly to Access tables as if they were directly connected to other databases through ODBC. DAO is best suited for single-system applications or for use locally on a small scale. Its internal Jet database access has been accelerated and optimized, and it is also very convenient to use. So if the database is an Access database and is used locally, it is recommended that you use this access method.

Three RDO (Remote Data Objects) remote data object is an object-oriented data access interface to ODBC. It is combined with easy-to-use DAO style to provide an interface that formally shows the underlying functions and flexibility of all ODBC. Although RDO is limited in terms of good access to Jet or ISAM databases, it can only access relational databases through existing ODBC drivers. However, RDO has proved to be the best interface of choice for many SQL Server, Oracle, and other large relational database developers. 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 throughout the organization. OLE DB is an open specification based on ODBC functions. ODBC is specifically developed for accessing relational databases, while OLE DB is used to access relational and non-relational information sources, 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 that encapsulate various database management system services and allow the creation of software components to implement these services. OLE DB components include data providers (containing and representing data), data consumers (using data), and service components (processing and transferring data, such as query processors and cursor engines). The OLE DB interface helps to integrate components smoothly so that OLE DB component vendors can quickly provide high-quality OLE DB components to the market. In addition, OLE DB includes a "bridge" to ODBC, providing consistent support for a variety of existing ODBC relational database drivers.

Five ADO (ActiveXData Object) is the subsequent product of DAO/RDO. ADO2.0 is more similar to RDO in functionality, and in general, there is a similar mapping between the two models. ADO "extends" the object model used by DAO and RDO, which means 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 it will focus on ADO in the future and will no longer upgrade DAO/RDO, so ADO has become the mainstream of current database development. There are three data stores involved in ADO: DSN (data source name), ODBC (open data connection) and OLEDB.

This is the end of the content of "what are the differences between ADO,OLEDB,ODBC,DAO,RDO". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.