Improve company productivity with a Business Account.Sign Up

x
?
Solved

Datacontrol vs Object

Posted on 2004-08-16
3
Medium Priority
?
273 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
2 Comments
 
LVL 14

Expert Comment

by:Farzad Akbarnejad
ID: 11807611
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 150 total points
ID: 11809682
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
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 fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

608 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