Chapter 27. Using ADO with ODBC

Table of Contents

27.1. What is ADO?

27.2. ADO Features

27.3. Using ADO

27.4. 9 Classes and 4 Collections

27.4.1. Classes
27.4.2. Collections

27.5. ADO Object Model

27.6. Accessing EnterpriseDB using ADO

27.6.1. ASP Example using VB Script
27.6.2. For a Stored Procedure
27.6.3. For a Function
27.6.4. Another Example of a Function Call
27.6.5. Visual C++ Example

This chapter specifies details of the support of ADO in ODBC provided in our product EnterpriseDB.

27.1. What is ADO?

ADO is a Microsoft technology. It stands for ActiveX Data Objects.ADO is basically a Microsoft Active-X component. It is automatically installed with Microsoft IIS. It is basically a programming interface for accessing data in a database. ADO can be used to access databases from web pages.

ActiveX Data Objects(ADO) enable you to write a client application to access and manipulate data in a database server through a provider. ADO's primary benefits are ease of use, high speed, low memory overhead,and a small disk footprint. ADODB is an implementation of ADO optimized for use with Microsoft OLE DB providers, including the Microsoft ODBC Provider for OLE DB (Object Linking and Embedding DataBase).

ADO provides an object-oriented programming interface for accessing a data source using the OLEDB data provider. It is the successor to DAO and RDO object models and combines the best features of DAO and RDO.

Programming OLEDB in C++ is easy. However, for languages like Visual Basic that do not support pointers and other C++ features, implementing OLEDB is difficult.

This is where ADOreally shines. ADO is a high level interface to OLEDB that is based on COM interfaces. Thus any application that supports COM can implement ADO.