General discussion

Locked

ADO

By mvlawrence ·
What is the difference between DAO,RDO,ADO in VB?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ADO

by Don Christner In reply to ADO

RDO is not really used any more.
DAO is not going to be improved any more.
ADO is the latest and greatest. However, depending on the app. it's between 1/3 to 1/2 slower than DAO.

You can use any of them to connect to a datasource.

Don

Collapse -

ADO

by mvlawrence In reply to ADO

The question was auto-closed by TechRepublic

Collapse -

ADO

by RRV In reply to ADO

Data Access Objects [DAO] uses MS Jet engine and supports ISAM databases and limited to query processing, synchronous, less capability cursor etc.
Remote Data Objects [RDO] is uses ODBC datasources to manipulate high end databases [optimised for MSSQL server & Oracle]. It supports synchronous & asynchronous queries, high complex queries etc with no compromise in speed.
ActiveX Data Objects [ADO] basically has 3 objects called Command, Recordset and Connection. Basically is a activeX technology using COM and requires MS platform as earlier. But has the highest available features to access virtually any database on network without optimising in performance, speed etc. In VB you can use any of these technologies. Suggestion : Use ADO 2.7. Watch out there is no more development in ADO. Hereafter everything is going to be .NET. If you have tried all these technologies pls try .NET. It is absolutely fantastic.

Collapse -

ADO

by mvlawrence In reply to ADO

The question was auto-closed by TechRepublic

Collapse -

ADO

by mvlawrence In reply to ADO

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums