VB Data Object

Posted on 1999-12-04
Medium Priority
Last Modified: 2012-06-21
I am developing Banking Application with SQL-Server - 7.0
I want to known which data object has good connection speed
and with less resources.
 RDO  Or   ADO ?

I have heared ADO still has some bugs with vb-6.0 but
I think in ADO, ActiveX Componants of ADO and COM its-self
   spend resources of client
Question by:nkhusain
1 Comment

Accepted Solution

beregoth earned 40 total points
ID: 2254802
Easy one...ADO all the way.  What some good reasons or is that enough?  Just kidding.

Microsoft announced some time ago that they would begin to phase out use and support in the application development strategies, the use of DAO and RDO...that in and of itself makes the question easy.

Furhtermore, ADO is much more robust than RDO offering some very powerful asychronous operation capabilities with recordset, connection, and command objects that were not previously available...offering unprecedented control over giving the user more information about what is happening during heavy data processing.

ADO, obviously an ActiveX COM object, supports OLE DB for more tightly integrated access to your databases.  If you are going to continue to use SQL Server, this will please you to know end...especially if you are fortunate enough to use the new Data Environment Designers in 6.0 which tie in to the technology tightly and integrate well with MS SQL Server.

ADO is a good strong model that yes, needs improvement.  There are always decisions that have to be made as to which is the best driver to use, should I be doing more processing on the server vs. client...what kind of recordset do I really want to get back.  But it is always improving and so far, Microsoft has been pretty good at deprecating funcationality, not elminating it..and 2.5 promises to be even better.

Finally, the nice and easy extensibility factor.  If you write a middleware piece as an ActiveX DLL using ADO, you will be able to use that same DLL from an ASP page in your inevitable move to web based development.  If you have a very basic model computer ADO can pig out a little but with anything over 64 Meg of memory and 133 mhz I have never even questioned its performance.

So scalability, good architecture, Microsofts choice for the future and extensibility...even into XML...all these reasons make the choice simple and forward thinking.

Hope that helps you to make a decision.

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question