RDO nicely wraps most of the functionality of the ODBC API, which specializes in accessing ODBC data sources. RDO almost complete all the functions that can be done with the ODBC API. RDO can support large database systems, such as SQL Server,oracle and Sybase, and it can also handle complex stored procedures and result sets.
ADO contains all of the features of ODBC, and it is as simple to use as RDO, so ADO will gradually replace RDO.
In general, developers can choose RDO to access a data source in the following situations:
(1) The background database of the application system is a large ODBC-driven data source, such as SQL Server,oracle.
(2) Application system requires faster database access speed, and the need to deal with complex stored procedures, users are unwilling to enter the underlying ODBC API programming, want to shorten the programming time.
(3) The user wants to make the modification to an original system, but the original system uses is RDO, and the scale is big, transplant it to ADO to need to spend a lot of time and money.