Page 508 - Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

The ADO Object Model

There are three main objects in the ADO object model. (See Figure 23-2.) The Connection
object represents the information needed to establish the connection between the data
consumer and the data provider. The Command object contains information about an
SQL statement or other database command that will be executed by the database server.
The Recordset object contains the rows from the virtual table that was created by the
Command object.

Connection
Object

Errors
Collection

Connection Connection
Object Object

Parameters
Collection

Recordset Parameter
Object Object

Fields
Collection

Field
Object

Figure 23-2. A few key objects comprise the ADO object model.

In addition to these objects, there are also a few other objects that support these main objects.
Chapter 23
Those supporting objects are the Error object, which contains information about any errors
that occur, and the Parameter object, which contains information about any parameters
associated with the Command object. The Field object contains information about a column
returned in the Recordset object.

482
Part 6: Excel and the Outside World: Collaborating Made Easy