...difference between ADO and DAO

<< Back to: FAQ: (1/95) comp.lang.basic.visual.* General Frequently Asked Questions

Answer by Yasir
Submitted on 11/18/2006
Rating: Not yet rated	Rate this answer:
General Differences Three distinct object models in ADO together provide the functionality found in DAO. These three models are ADO (ADODB), Microsoft ADO Extensions for DDL and Security (ADOX), and Microsoft Jet and Replication Objects (JRO). The functionality of DAO is divided among these three models because many applications will need just one of these subsets of functionality. By splitting the functionality out, applications do not need to incur the overhead of loading additional information into memory unnecessarily. The following sections provide an overview of these three object models. ADO: Data Manipulation ADO enables your client applications to access and manipulate data through any OLE DB Provider. ADO contains objects for connecting to a data source and reading, adding, updating, or deleting data. or find the complete refrence at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoado.asp Thanks

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: FAQ: (1/95) comp.lang.basic.visual.* General Frequently Asked Questions

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Adi
Submitted on 10/15/2003
Related FAQ: FAQ: (1/95) comp.lang.basic.visual.* General Frequently Asked Questions
Rating:	Rate this question:
What is difference between ADO and DAO

Answer by nels
Submitted on 12/4/2003
Rating:	Rate this answer:
dao- u can access only access database ado-u can access any databases

Answer by zab
Submitted on 11/11/2004
Rating: Not yet rated	Rate this answer:
ldmdkdjndfnkjinjfn bjdbfn ddkfnb

Answer by shivangi
Submitted on 12/1/2004
Rating: Not yet rated	Rate this answer:
Data Access Objects is used to access ms access type databases it can also be used to access any database in combination with ODBC,,whereas ADO is the latest technology to access database it provides facilities to perform complex operations on databases with much ease,,ADO can be used in web also

Answer by cathy
Submitted on 3/9/2005
Rating: Not yet rated	Rate this answer:
DAO: Workspace level support. Both MFC and API provides DAO support. Speed is relatively faster than ODBC for jet database engine databases. ADO : Workspace-level support. Fastest method to access various kind of databases. Easy to use fi you are familiar with COM environment. Provides access to relational, non relational and other types of data.

Answer by jeseekm
Submitted on 8/4/2005
Rating: Not yet rated	Rate this answer:
ado:used to access and manipulate data in a database dao: data access objects,provide a framework for using code to create and manipulate databases.

Answer by cerniumtec
Submitted on 12/7/2005
Rating: Not yet rated	Rate this answer:
I know

Answer by Vadivel P.
Submitted on 3/22/2006
Rating: Not yet rated	Rate this answer:
ADO is an ActiveX Object which is more simpler to access the Remote Database and it supports Open Databases or any RDBMS. DAO is an Ordinary object which is quite complicated to access the Remote Database(ie. selected RDBMS can be accessed using this.)

Answer by Mr.Maruthu
Submitted on 4/15/2006
Rating: Not yet rated	Rate this answer:
ADO: It is Convensional and Non Convensional Data Base DAO:It is Design for Only Native Data Base

Answer by Khizra Javaid
Submitted on 5/24/2006
Rating: Not yet rated	Rate this answer:
DAO (for Jet) i)Dim Db As Database ii) Set Db = DBEngine(0)(0) Set Db = OpenDatabase(Name, Options, ReadOnly, Connection) ADO i) Dim Cn as New ADODB.Connection ii) Set cn = application.CurrentProject.Connection Cn.Open ConnectionString, IDUser, Password, Options

Answer by dsfds
Submitted on 5/27/2006
Rating: Not yet rated	Rate this answer:
dfdsfdsf

Answer by azee
Submitted on 10/16/2006
Rating: Not yet rated	Rate this answer:
I don't know

Answer by Sen S D
Submitted on 11/13/2006
Rating: Not yet rated	Rate this answer:
ADO is Microsoft data access technology for most data sources. but DAO is used for speed access for MS access database.

Answer by Battula Raveendrababu
Submitted on 12/26/2006
Rating: Not yet rated	Rate this answer:
ADO is a superset of DAO in functionality point of view. In fact ADO is a combination of DAO + RDO

Answer by rinku
Submitted on 2/10/2007
Rating: Not yet rated	Rate this answer:
we can use ado to access newer version of databases as well as older version of databases. we can use dao to access older version of databases.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: