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. |