ADO in the CML Application

ActiveX® Data Objects (ADO) is a high-level interface to all kinds of data. ADO provides consistent, high-performance access to data, whether you're creating a front-end database client or a middle-tier business object using an application, tool, language, or even an Internet browser. ADO is the single data interface you need to know for 1- to n-tier client/server and Web-based data-driven solution development. ADO is optimized for Web applications and visual programming environments. ADO effectively supercedes DAO and RDO.

The ADODB data object is installed with ADO. The CML application uses the following ADO objects and collections: connection, command, recordset, fields, parameters, properties, and error.

How the CML application benefits from using ADO:

• Enhanced performance. ADO is fast.
• Fast development. ADO helps minimize development cost.
• ADO is easy to use. The ADO object model is not as complex as that of RDO or DAO and therefore is easier to use, with less coding required.
• ADO combines the best features of, and has replaced, RDO and DAO.
• ADO is based on COM. It provides many functional data access technologies through object interfaces based on ActiveX and COM.
• ADO is language-neutral. Because ActiveX is a language-neutral technology, developers are given considerable freedom to choose an appropriate development tool or language for a given solution, while maintaining consistent data access constructs and capabilities.
• ADO is suited for Web applications and multitier architecture.
• ADO can be used to access all types of data, whereas RDO and DAO access only relational data.
• ADO is suitable to call from lnternet interfaces. It has no pointers, structures, or explicit memory management.
• ADO is the standard data access object model across Microsoft tools, including Microsoft® Visual Basic®, Access, Office, and Internet Information Server.