Solved

Datacontrol vs Object

Posted on 2004-08-16
3
202 Views
Last Modified: 2010-04-17
What's the difference between using:
a) ADODC or ADO object
b) MSRDC or RDO object
Which I must we prefer - the datacontrol or the corresponding object?And why?
Is there any difference,in terms of,scalability or flexibility or usability or whatever?
0
Comment
Question by:EXwithRaj
3 Comments
 
LVL 14

Expert Comment

by:Farzad Akbarnejad
Comment Utility
Hi,
Developing with Datacontrols is faster that Objects
Scalability of Objects is better that Datacontrols
Usability is equal for both of them.

-FA
0
 
LVL 4

Accepted Solution

by:
rlibrandi earned 50 total points
Comment Utility
I have to take exception to FA's comment about developing with datacontros being faster than objects (ADO).  DESIGN is easier and faster, but try writing queries against datasources and linked tables especially when more than two or three tables are involved.  It's much easier to created an ADO recordset and open it with a SQL query and populate textboxes with the results.  Also, there is a huge difference in opening up a form with non-attached elements than having the form do its connections and queries just to connect to the database.  Data objects are definitely they way to go.  The app is much more portable between database systems as well.  Database names might change in the future or the database OS might change as well.  Using ADO, you only need to change your connection string or DSN to connect -- The same SQL Statements will work between Access, SQL Server, Oracle, DB2, .......
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
copyEndy  challenge 15 53
for loop with Set 4 45
topping3 challenge 14 48
word0 challenge 3 55
RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now