SQL Server 6.5 Database Access 
Author Message
 SQL Server 6.5 Database Access

What is it better to use DAO or ADO?


Tue, 29 Apr 2003 03:00:00 GMT  
 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  
 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  
 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  
 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  
 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  
 
 [ 6 post ] 

 Relevant Pages 

1. VBScript Error due to converting databases from Access to SQL Server 6.5

2. Writing data from VB 5.0 to a SQL Server 6.5 database

3. Help needed: User permissions in a SQL Server 6.5 database

4. Writing data from VB 5.0 to a SQL Server 6.5 database

5. Pessimistic Recordlocks Access --> SQL Server 6.5

6. Access 97 and SQL Server 6.5

7. Syntax for VB6.0 to access SQL Server 6.5

8. migration vb3.0: from access 2.0 to sql server 6.5

9. I need, must have program for converting Access DB to SQL server 6.5 Script

10. Syntax for VB6.0 to access SQL Server 6.5

11. Access to SQL Server 6.5

12. Moving from access to sql server 6.5

 

 
Powered by phpBB® Forum Software