Tuesday, 14 February 2017

What is the difference between ADO, RDO and DAO?

DAO
ADO
RDO
Data Access Object is used for accessing data before ADO.
Active Data Object is more powerful till Date. It is nothing but combination of both DAO and RDO.
Remote Data Object is used for Accessing remote data.
DAO can access MS-Access Database.
ADO is universal data access object, it can access both relational and non relational database. 
RDO can access client server database.
In this control set the DatabaseName and Record Source Property.
In this control, set ConnectionString and RecordSource property.
In this control, set DataSourceName and SQL property.

No comments:
Write comments