Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What is the difference between DAO, RDO and ADO?

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-02-2009
Member
 
Join Date: Jan 2009
Posts: 18
What is the difference between DAO, RDO and ADO?
  

Hi,

What is the difference between DAO, RDO and ADO?

Reply With Quote
  #2  
Old 28-02-2009
Member
 
Join Date: Feb 2009
Posts: 7
Re: What is the difference between DAO, RDO and ADO?

Direct Access Objects(DAO)
RDO(Remote Data Objects)
ActiveX Data Objects (ADO)
Reply With Quote
  #3  
Old 28-02-2009
Member
 
Join Date: Jan 2009
Posts: 36
Re: What is the difference between DAO, RDO and ADO?

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.
Reply With Quote
  #4  
Old 28-02-2009
Member
 
Join Date: Jan 2009
Posts: 9
Re: What is the difference between DAO, RDO and ADO?

DAO is old style, dont use it. It is the original data connector. RDO was the next generation, mostly used for connections to SQL servers, but not used heavily. ADO is the way to go. It is support and is Microsofts primary system for connecting to databases. The same code can be used in almost all the VBscript systems out there including ASP pages. You could learn about the others, but they will just be learning the past. Just my advice.
Reply With Quote
  #5  
Old 28-02-2009
Member
 
Join Date: Oct 2005
Posts: 2,385
Re: What is the difference between DAO, RDO and ADO?

DAO, RDO, ADO and OLE DB are data access methods that all accomplish exactly the same task.

DAO - Data Access Objects (1-tier)
Allow VB applications to talk to a database (the JET Engine) via ODBC. DAO was Microsoft's first object oriented solution for the manipulation of databases using the Jet Database Engine. The JET engine duplicates the functionalities of ODBC, and thus does not add much value. As the JET engine is generic, many of Oracle's features would not be accessible. Microsoft is phasing out this method.

RDO - Remote Data Objects (2-tier)
Allow VB applications to talk to a relational database (various Relational DBMSs) via ODBC. RDO is an interface to remote RDBMS via OBDC. One needs the Enterprise Edition of Visual Basic to use RDO. Microsoft is encouraging developers to migrate their RDO programs to ADO and OLE-DB.

ADO - ActiveX Data Objects (1 to n-tier)
Allow VB/Other Web Tools (Browsers) to interface with different kinds of data sources. ADO is a more recent Microsoft Data Access technology designed to replace DAO and RDO. ADO is designed to be simpler to use and more powerful than DAO/RDO. Serves an interface to Microsoft's new OLE-DB technology (thinner than ODBC). Can be used to access all sorts of "non traditional data" (e.g., web pages/documents, etc.).

OLE DB data provider
OLE DB is Microsoft's successor to ODBC that utilizes a set of COM interfaces for accessing and manipulating of data. Oracle implemented OLE DB as part of their "Oracle Provider for OLE DB" client software. It provides interface for both data-consuming applications and database providers. OLE DB is considered a thin middle layer which provides better data access performance.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is the difference between DAO, RDO and ADO?"
Thread Thread Starter Forum Replies Last Post
What is difference between RAM and ROM? Harper 21 Motherboard Processor & RAM 5 30-01-2010 08:00 AM
Difference between OOP and AOP Sarfaraj Khan Software Development 5 20-01-2010 08:20 AM
Difference between jsp and asp.net Crespin Software Development 3 24-11-2009 05:57 AM
Difference between wap and wep Soggy Bottom Networking & Security 3 23-11-2009 08:34 AM
Difference between IDE and ATA LALETTE Hardware Peripherals 3 09-01-2009 09:34 AM


All times are GMT +5.5. The time now is 08:12 PM.