ADO VS. DAO [英] ADO VS. DAO

问题描述

我应该在Access Databases 2000及更高版本中使用哪一个？哪一个是

更新，更好还是推荐？

Which one should I use for Access Databases 2000 and up? Which one is
newer, better and recommended?

推荐答案

这是一个相对的问题。如果您使用Access数据项目

（.adp）与sql server连接，则必须使用ADO，因为

sql server不支持DAO。如果您使用的是mdb，那么您可以在ADO和DAO之间选择

。我的感觉是DAO更适合用于mdb'的
，因为mdb是基于Jet的DAO设计的，其中

ADO更适合sql服务器引擎类型。


Rich


***通过Developersdex发送 http://www.developersdex.com ***

This is a relative question. If you are using an Access data project
(.adp) for interfacing with sql server you will have to use ADO because
sql server does not support DAO. If you are using an mdb then you have
a choice between ADO and DAO. My feeling is that DAO is better suited
for mdb''s since the mdb is Jet based for which DAO was designed, where
ADO is more suited for a sql server type of engine.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

我同意Rich的观点。当我开始时，我使用ADO作为mdbs，因为

微软说ADO是更新，更好，更推荐，但后来我决定了b $ b（在如果你确定你的项目是一个mdb并保持mdb（或

mde），DAO是更好的选择。


" Karen Hill" < KA ********** @ yahoo.com>在消息中写道

news：11 ********************** @ t31g2000cwb.googlegr oups.com ...

I agree with Rich. When I was starting out, I used ADO for mdbs because
Microsoft said that ADO was "newer and better and recommended", but then I
decided (with help from this group and reading) that DAO is the better
choice if you''re sure your project is going to be an mdb and stay an mdb (or
mde).

"Karen Hill" <ka**********@yahoo.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

我应该在Access Databases 2000及更高版本中使用哪一个？哪一个更新，更好，更推荐？

Which one should I use for Access Databases 2000 and up? Which one is
newer, better and recommended?

Per Karen Hill：

Per Karen Hill:

我应该使用哪一个访问数据库2000及以上？哪一个更新，更好，更推荐？

Which one should I use for Access Databases 2000 and up? Which one is
newer, better and recommended?

如果你的后端是.mdb，DAO会提供更多功能并减少编码。


如果您的后端是C / S，ADO会为您提供更多功能 - 例如流水线

单个连接/命中的多个结果集。

对于我的钱，你应该使用DAO来反对.MDBs和ADO for C / S.


DAO链接适用于C / S - 也许他们是'在一些

的情况下做正确的事情......但我仍然喜欢ADO和存储过程。

-

PeteCresswell

If your back end is .mdb, DAO gives more functionality and takes less coding.

If your back end is C/S, ADO gives you more functionality - like pipelining
multiple result sets down a single connection/hit.

For my money, you should use DAO for going against .MDBs and ADO for C/S.

DAO links will work for C/S - and maybe they''re the right thing to do under some
circumstances.... but I''d still favor ADO and stored procedures.
--
PeteCresswell

这篇关于ADO VS. DAO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！