DAO and RDO and ADO

[SKG]

Can any one help me understand what are Direct Access Objects(DAO)
RDO(Remote Data Objects) and ActiveX Data Objects (ADO) and their
difference.
And where do ODBC layer comes in these.
Also what the major improvement in Visual Studio.Net in terms of database
access.

Thanks!!!

 

[Steve C. Orr [MVP, MCSD]]

DAO is really old and was really meant for interacting with MS Access.
RDO came next. It was more flexible but it still old and crusty by today's
standards.
ADO came next and allowed all kinds of data sources (often times by using
ODBC). ADO was great, but not very scalable and it was based on old COM
technologies.
Thus, ADO.NET came along and that is what all modern developers use. It is
currently the best solution around for nearly any kind of data needs.