ADO Object Summary
| Object | Description |
| Connection | Enables exchange of data. |
| Command | Embodies an SQL statement. |
| Parameter | Embodies a parameter of an SQL statement. |
| Recordset | Enables navigation and manipulation of data. |
| Field | Embodies a column of a Recordset object. |
| Error | Embodies an error on a connection. |
| Property | Embodies a characteristic of an ADO object. |
ADO Collection Summary
| Collection | Description |
| Errors | All the Error objects created in response to a single failure on a connection. |
| Parameters | All the Parameter objects associated with a Command object. |
| Fields | All the Field objects associated with a Recordset object. |
| Properties | All the Property objects associated with a Connection, Command, Recordset or Field object. |
ADO Event Handler Summary
| ConnectionEvents | Description |
| BeginTransComplete, CommitTransComplete, RollbackTransComplete |
Transaction Management—Notification that the current transaction on the connection has started, committed, or rolled back. |
| WillConnect, ConnectComplete, Disconnect | Connection Management—Notification that the current connection will start, or has started or ended. |
| WillExecute, ExecuteComplete | Command Execution Management—Notification that the execution of the current command on the connection will start, or has ended. |
| InfoMessage | Informational—Notification that there is additional information about the current operation. |
| RecordsetEvents | Description |
| FetchProgress, FetchComplete | Retrieval Status—Notification of the progress of a data retrieval operation, or that the retrieval operation has completed. |
| WillChangeField, FieldChangeComplete | Field Change Management—Notification that the value of the current field will change, or has changed. |
| WillMove, MoveComplete, EndOfRecordset | Navigation Management—Notification that the current row position in a Recordset will change, has changed, or has reached the end of the Recordset. |
| WillChangeRecord, RecordChangeComplete | Row Change Management—Notification that something in the current row of the Recordset will change, or has changed. |
| WillChangeRecordset, RecordsetChangeComplete | Recordset Change Management—Notification that something in the current Recordset will change, or has changed. |
Next … Solutions for Remote Data Access.