ActiveX Data Objects (ADO) is designed to be an easy-to-use application-level interface to any OLE DB data provider, including relational and non-relational databases, e-mail and file systems, text and graphics, and custom business objects, as well as existing ODBC data sources. Virtually all of the data available throughout the enterprise is available using the ADO data access technology.
ADO is easy to use, language-independent, implemented with a small footprint, uses minimal network traffic, and has few layers between the client application and the data source — all to provide lightweight, high-performance data access.
The general characteristics of ADO are:
- Ease of use.
- High performance.
- Programmatic control of cursors.
- Complex cursor types, including batch and server- and client-side cursors.
- Ability to return multiple result sets from a single query.
- Synchronous, asynchronous, or event-driven query execution.
- Reusable, property-changeable objects.
- Advanced recordset cache management.
- Flexibility — it works with existing database technologies and all OLE DB providers.
- Excellent error trapping.
The simple semantics of ADO and universal application mean minimal developer training, rapid application development, and inexpensive maintenance.
The following sections will acquaint you with ADO data access technology.