Results 1 to 5 of 5

Thread: What is the difference between DAO, RDO and ADO?

  1. #1
    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?

  2. #2
    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)

  3. #3
    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.

  4. #4
    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.

  5. #5
    Join Date
    Oct 2005
    Posts
    2,393

    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.

Similar Threads

  1. What is difference between RAM and ROM?
    By Harper 21 in forum Motherboard Processor & RAM
    Replies: 5
    Last Post: 30-01-2010, 09:00 AM
  2. Difference between OOP and AOP
    By Sarfaraj Khan in forum Software Development
    Replies: 5
    Last Post: 20-01-2010, 09:20 AM
  3. Difference between jsp and asp.net
    By Crespin in forum Software Development
    Replies: 3
    Last Post: 24-11-2009, 06:57 AM
  4. Difference between wap and wep
    By Soggy Bottom in forum Networking & Security
    Replies: 3
    Last Post: 23-11-2009, 09:34 AM
  5. Difference between IDE and ATA
    By LALETTE in forum Hardware Peripherals
    Replies: 3
    Last Post: 09-01-2009, 10:34 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,639,991.89147 seconds with 17 queries