ADO Objects and Collections

ADO consists of the following nine objects and four collections.

Object or Collection Description
Connection object Represents a unique session with a data source. In the case of a client/server database system, it may be equivalent to an actual network connection to the server. Depending on the functionality supported by the provider, some collections, methods, or properties of a Connection object may not be available.
Command object Used to define a specific command, such as a SQL query, intended to run against a data source.
Recordset object Represents the entire set of records from a base table or the results of an executed command. All Recordset objects consist of records (rows) and fields (columns).
Record object Represents a single row of data, either from a Recordset or from the provider. This record could represent a database record or some other type of object such as a file or directory, depending upon your provider.
Stream object Represents a stream of binary or text data. For example, an XML document can be loaded into a stream for command input or returned from certain providers as the results of a query. A Stream object can be used to manipulate fields or records containing these streams of data.
Parameter object Represents a parameter or argument associated with a Command object, based on a parameterized query or stored procedure.
Field object Represents a column of data with a common data type. Each Field object corresponds to a column in the Recordset.
Property object Represents a characteristic of an ADO object that is defined by the provider. ADO objects have two types of properties: built-in and dynamic. Built-in properties are those properties implemented in ADO and immediately available to any new object. The Property object is a container for dynamic properties, defined by the underlying provider.
Error object Contains details about data access errors that pertain to a single operation involving the provider.
Fields collection Contains all the Field objects of a Recordset or Record object.
Properties collection Contains all the Property objects for a specific instance of an object.
Parameters collection Contains all the Parameter objects of a Command object.
Errors collection Contains all the Error objects created in response to a single provider-related failure.

See Also

ADO Object Model