By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

ODBC and ADO

P: n/a
What does ODBC and ADO have in common ? Both can connect to different
data sources ? Whats the different between them . Pls advise.

Regards,
Daniel
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
da*******@time.net.my (Daniel Tan) wrote in
news:6a**************************@posting.google.c om:
What does ODBC and ADO have in common ? Both can connect to different
data sources ? Whats the different between them . Pls advise.

Regards,
Daniel


ABC are different.

DO are the same.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #2

P: n/a
Simply put, ADO has an object model (a collection of objects like
Connection, Command, Recordset, etc.) while ODBC can connect to a
variety of database systems, it does not have an object model.

da*******@time.net.my (Daniel Tan) wrote in message news:<6a**************************@posting.google. com>...
What does ODBC and ADO have in common ? Both can connect to different
data sources ? Whats the different between them . Pls advise.

Regards,
Daniel

Nov 12 '05 #3

P: n/a
Hi, so if i just want to use within Access , do i need to use ADO ?
would it incur any overhead compared to DAO ? what abt performance
wise ?

Regards,
Daniel

qu**********@angelfire.com (technolust) wrote in message news:<db**************************@posting.google. com>...
Simply put, ADO has an object model (a collection of objects like
Connection, Command, Recordset, etc.) while ODBC can connect to a
variety of database systems, it does not have an object model.

da*******@time.net.my (Daniel Tan) wrote in message news:<6a**************************@posting.google. com>...
What does ODBC and ADO have in common ? Both can connect to different
data sources ? Whats the different between them . Pls advise.

Regards,
Daniel

Nov 12 '05 #4

P: n/a
Both DAO and ADO will take up some memory, but ADO takes up less
memory and, is therefore, faster than DAO.
da*******@time.net.my (Daniel Tan) wrote in message news:<6a**************************@posting.google. com>...
Hi, so if i just want to use within Access , do i need to use ADO ?
would it incur any overhead compared to DAO ? what abt performance
wise ?

Regards,
Daniel

qu**********@angelfire.com (technolust) wrote in message news:<db**************************@posting.google. com>...
Simply put, ADO has an object model (a collection of objects like
Connection, Command, Recordset, etc.) while ODBC can connect to a
variety of database systems, it does not have an object model.

da*******@time.net.my (Daniel Tan) wrote in message news:<6a**************************@posting.google. com>...
What does ODBC and ADO have in common ? Both can connect to different
data sources ? Whats the different between them . Pls advise.

Regards,
Daniel

Nov 12 '05 #5

P: n/a
qu**********@angelfire.com (technolust) wrote in
news:db**************************@posting.google.c om:
Both DAO and ADO will take up some memory, but ADO takes up less
memory and, is therefore, faster than DAO.


In what context?

And where do you get this "fact?"

And what makes you think that less memory is always faster?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.