Remote Data Objects

Remote Data Objects ( RDO short ) refers to an obsolete programming interface from Microsoft on object- oriented basis to access database systems. She came primarily in Visual Basic applications.

RDO enables developers to directly access data sources in remote computers without having to deal with the complex ODBC interface. RDO provides functions to establish connections to databases, to ask there queries and edit the query results. RDO also supports stored procedures and transactions.

Remote Data Objects was in versions 4, 5, and 6 contain Visual Basic. The latest version is version 2.0.

Related Procedures

RDO was conceived by Microsoft as a supplement to the Interface Data Access Objects ( DAO). The beginning of the 90s, introduced Access database was operated by the Jet Engine. DAO allowed developers to access Jet through program code. The typical elements of relational databases such as tables, columns, relationships between tables and entries could thus be treated as program objects.

If, however, it was necessary to access data from existing server databases such as Oracle or DB2, DAO was subject to restrictions. To communicate with these databases, the ODBC protocol was used. The data were translated so that the external databases against DAO looked like a Jet database; a complicated and resource-intensive process. In order to access ODBC sources faster, DAO was asked the RDO interface to the side.

RDO used a different object model than DAO, so that later addition ODBCDirect was introduced, could be accessed directly from DAO to ODBC sources with the developer, in a way comparable to RDO speed. Later, DAO and RDO have been superseded by ActiveX Data Objects ( ADO) and OLE DB; ADO, however, could spread only slowly because of the initially reduced functionality and the wide use of DAO. The current database interface of Microsoft ADO.NET.