Remote Data objects and collections provide a framework for using code to create and manipulate components of a remote ODBC database system. Objects and collections have properties that describe the characteristics of database components and methods that you use to manipulate them. Using the containment framework, you create relationships among objects and collections, and these relationships represent the logical structure of your database system.
Objects and collections provide different types of containment relationships: Objects contain zero or more collections, all of different types; and collections contain zero or more objects, all of the same type. Although objects and collections are similar entities, the distinction differentiates the two types of relationships.
Note The RDO is only supported on 32-bit operating systems such as Windows 95 and Windows NT. To use the Remote Data Objects, you must set a reference to the Microsoft Remote Data Object 2.0 object library in the Visual Basic References dialog box.
In the following table, the type of collection in the first column contains the type of object in the second column. The third column describes what each type of object represents.
Collection | Object | Description |
rdoConnections | rdoConnection | An open or allocated connection |
None | rdoEngine | The remote database engine |
rdoErrors | rdoError | Information about ODBC errors |
rdoEnvironments | rdoEnvironment | A logical set of rdoConnection objects with a common user name and password |
rdoColumns | rdoColumn | A column that is part of an rdoResultset |
rdoParameters | rdoParameter | A parameter for an rdoQuery or an rdoPreparedStatement |
rdoPreparedStatements | rdoPreparedStatements | A saved query definition (outdated) |
rdoQueries | rdoQuery | A saved query definition |
rdoResultsets | rdoResultset | The rows resulting from a query |
rdoTables | rdoTable | A table definition |