ODBC and ADO

[Daniel Tan]

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

Regards,
Daniel

[Lyle Fairfield]

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)

[technolust]

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

[Daniel Tan]

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

[technolust]

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

[David W. Fenton]

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