Visual Basic/VB, SQL Server 6.5 Database Access

Harle
#1 / 6

SQL Server 6.5 Database Access

What is it better to use DAO or ADO?

Tue, 29 Apr 2003 03:00:00 GMT

Tyler Sha
#2 / 6

SQL Server 6.5 Database Access

Don't quote me on this but I think ADO is DAO but trimmed down a bit. I
like ADO, it seems to me faster.

--
Tyler Shaw
Computer Specialist
Caduceus Healthcare LTD.
www.caduceus-healthcare.com

Quote:

> What is it better to use DAO or ADO?

Tue, 29 Apr 2003 03:00:00 GMT

Garth Burril
#3 / 6

SQL Server 6.5 Database Access

Use ADO! DAO carries a lot of overhead. ADO is quicker and much smaller.
You do not have the hierarchy of objects like DAO.

Garth Burrill
Strategic Power Systems
Customer Solutions Developer

Quote:

> What is it better to use DAO or ADO?

Tue, 29 Apr 2003 03:00:00 GMT

Jeff Kir
#4 / 6

SQL Server 6.5 Database Access

I can't see any reason that somebody should be using DAO anymore.
ADO is far superior to DAO in many many aspects.

Enjoy,
Jeff Kirk
Visual Basic Team Leader

Quote:

-----Original Message-----

What is it better to use DAO or ADO?

.

Wed, 30 Apr 2003 03:00:00 GMT

Elan Zh
#5 / 6

SQL Server 6.5 Database Access

Hi,

ADO has more advantages over DAO and for new applications, the ADO should
be used. Here is a simple comparison between ADO,RDO and DAO at
http://www.msdn.microsoft.com/library/default.asp?URL=/library/devpro...
vbasic/vbcon98/vbconUsingADODAORDOInVisualBasic.htm .

Best Regards,
Elan Zhou

Fri, 02 May 2003 03:00:00 GMT

Paul Browe
#6 / 6

SQL Server 6.5 Database Access

Just remember, that everytime someone sneezes at Microsoft, a new version of
ADO seems to be released. If you're going to rely on ADO, you may want to
consider using an application server (3-tier). You can have the application
server run ado, and then you only have to control the server environment,
instead of all user pc's.

--
Paul Brower
http://www.browerconsulting.com
DO NOT EMAIL ME

Quote:

> Use ADO! DAO carries a lot of overhead. ADO is quicker and much smaller.
> You do not have the hierarchy of objects like DAO.

> Garth Burrill
> Strategic Power Systems
> Customer Solutions Developer

> > What is it better to use DAO or ADO?

Fri, 02 May 2003 03:00:00 GMT