为什么选择ADO而不是DAO？ [英] Why ADO rather than DAO?
问题描述
我从Access 97转移到Access 2003.到目前为止，太棒了。
我正在读在我的一本A2003开发者书籍中讨论。
其他人对两者都有一个很好的解释，但提到她建议使用ADO完成所有新开发的
。但她并没有说出原因！
主要是因为DAO正在被逐步淘汰？使用ADO的好处是什么？
这个时机很棒，因为我刚开始申请新的
使用Access 2003.
-pw
在spamcop dot net上使用paulwilliamson发送电子邮件
Hi,
I made the move to Access 2003 from Access 97. So far, so great.
I am reading a discussion in one of my A2003 developer books. The
other has a nice explanation of both but mentions that she recommends
that all new development be done using ADO. But she doesn''t say why!
Is it primarily because DAO is being phased out? What are the
benefits of using ADO instead?
The timing for this is great, as I have just started a new application
using Access 2003.
-pw
use paulwilliamson at spamcop dot net for e-mail
推荐答案
pa ******** **********@removespamcop.net 写道：
我从Access 97迁移到Access 2003.所以很好。
我正在阅读A2003开发者书籍中的一篇讨论。
其他人对两者都有很好的解释，但提到她建议使用ADO完成所有新开发。但她并没有说出原因！
主要是因为DAO正在被逐步淘汰？使用ADO有什么好处？
这个时机非常棒，因为我刚刚使用Access 2003启动了一个新的应用程序。
Hi,
I made the move to Access 2003 from Access 97. So far, so great.
I am reading a discussion in one of my A2003 developer books. The
other has a nice explanation of both but mentions that she recommends
that all new development be done using ADO. But she doesn''t say why!
Is it primarily because DAO is being phased out? What are the
benefits of using ADO instead?
The timing for this is great, as I have just started a new application
using Access 2003.
这个问题可能已被讨论过致死。所以也许可以试试
Google档案？
DAO将会存在很长时间。我个人认为没有理由将b $ b转移到ADO，除非你转向ADP / MSSQL后端.....但是
那只是我：） />
-
问候，
布拉德利
基督徒的回应
http://www.pastornet.net.au/response
pa * *****************@removespamcop.net 写道：
我搬到了从Access 97访问2003.到目前为止，非常棒。
我正在阅读A2003开发人员书籍中的讨论。
其他人对两者都有很好的解释，但提到她建议使用ADO完成所有新开发。但她并没有说出原因！
主要是因为DAO正在被逐步淘汰？使用ADO有什么好处？
这个时机非常棒，因为我刚刚使用Access 2003启动了一个新的应用程序。
-pw
Hi,
I made the move to Access 2003 from Access 97. So far, so great.
I am reading a discussion in one of my A2003 developer books. The
other has a nice explanation of both but mentions that she recommends
that all new development be done using ADO. But she doesn''t say why!
Is it primarily because DAO is being phased out? What are the
benefits of using ADO instead?
The timing for this is great, as I have just started a new application
using Access 2003.
-pw
Paul，
DAO和ADO都被淘汰，但两者仍然继续存在
并且两者都解决了一系列不同但重叠的需求。
如果您的数据在MDB中，那么普遍的共识似乎是（即
Jet）然后DAO比ADO更有效率。相反，如果您的数据是/ b $ b SQL Server，则ADO比DAO更有效。
如果您的需求适合仅适用于这些工具之一的区域
然后，当然，你将不得不使用该工具。你可以在DAO中做很多事情，但ADO中没有这些东西。还有一些东西可以在ADO中完成DAO不能做的事情，但我不需要任何这些（并且不能）甚至真的想到它们中的任何一个，但我知道它们存在）。
就个人而言，我在Access中使用DAO，包括针对Linked
SQL Server表。效率的损失（我的经验最少）是值得我在各种应用程序内部和之间编码的一致性。
我的编程效率也高得多，因为DAO因为它是
我更有经验的。我在ASP网站应用中只使用了ADO
，因为没有DAO选项。
-
Bri
Paul,
Both DAO and ADO are being ''phased out'', but both still continue to
exist and both solve a different, but overlaping, set of needs.
The general consensus seems to be that if your data is in an MDB (ie
Jet) then DAO is more efficient than ADO. Conversely, if your data is
SQL Server then ADO is more efficient than DAO.
If your needs fit into the area only available to one of these tools
then, of course, you will have to use that tool. There are many things
you can do in DAO that are not available in ADO. There are also things
that can be done in ADO that DAO can''t do, but I haven''t needed any of
these (and can''t even really think of any of them but I know they exist).
Personally, I use DAO for everything in Access, including against Linked
SQL Server tables. The loss of efficiency (minimal in my experience) is
well worth the consistency of coding within and between my various apps.
My programming efficiency is also much higher with DAO because it is
what I''m more experienced in. I have only used ADO in ASP website apps
as there is no DAO option.
--
Bri
pa ****************** @ removespamcop.net 写道：
pa******************@removespamcop.net wrote:
我从Access 97迁移到Access 2003.到目前为止，非常棒。
我在一个人阅读讨论我的A2003开发者书籍。
其他人对两者都有很好的解释，但提到她建议使用ADO完成所有新开发。但她并没有说出原因！
主要是因为DAO正在被逐步淘汰？使用ADO有什么好处？
这个时机非常棒，因为我刚刚使用Access 2003启动了一个新的应用程序。
Hi,
I made the move to Access 2003 from Access 97. So far, so great.
I am reading a discussion in one of my A2003 developer books. The
other has a nice explanation of both but mentions that she recommends
that all new development be done using ADO. But she doesn''t say why!
Is it primarily because DAO is being phased out? What are the
benefits of using ADO instead?
The timing for this is great, as I have just started a new application
using Access 2003.
如果您使用Jet，请坚持使用DAO，因为DAO是Jet原生的。对于其他后端，ADO更多是
（尽管我仍在使用DAO与Oracle，例如
）。一个可怕的例子，是一个未绑定的形式，当我做了
更改并使用ADO执行更新或插入SQL语句时，
关闭了未绑定的表单并返回到绑定连续形式，即使有多个重新查询，也不会显示
更新/插入。有时
它会在一分钟之后神奇地出现，其他时候，我不得不关闭绑定形式并重新打开它。这个小组的定期撰稿人
向我展示了一个方法，但MS技术人员告诉我这是因为我使用DAO更好地使用
。
上面的解释正是一个Access手机技术
向我解释的最后一个FAll当我处于完全相同的情况时你现在发现自己。我有点失望，因为我确实想要学习新方法。但考虑到我的工作要求（这是管理层），我没有时间。 8（
-
Tim http://www.ucs.mun.ca/~tmarshal/
^ o<
/＃）" Burp-beep， burp-beep，burp-beep？ - Quaker Jake
/ ^^Whatcha doin？ - 同上TIM-MAY !! - 我
If you''re using Jet, stick with DAO as DAO is native to Jet. ADO is
more for other back ends (though I''m still using DAO with Oracle, for
example). One horrible example, was in an unbound form, when I made
changes and used ADO to perform an update or insert SQL statement,
closed the unbound form and returned to a bound continuous form, the
update/insert would not show, even with multiple requeries. Sometimes
it would magically appear up to a minute later, other times, I had to
close the bound form and reopen it. A regular contributor to this group
showed me a way around it but the MS techs told me this was because I
was better off using DAO.
And that explanation above is exactly what an Access phone tech
explained to me last FAll when I was in exactly the same situation you
now find yourself. I was a little disappointed, because I did want to
learn new methods. But given the demands on my job (which is
managerial), I don''t have the time. 8(
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
这篇关于为什么选择ADO而不是DAO？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
