Remote Data Objects and Collections

               

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