Solved

Datacontrol vs Object

Posted on 2004-08-16
3
249 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 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 50 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
egit plugin on eclipse 8 126
Regular Expression Calculator Tester 2 96
Error building VS2105 solution from repository 1 59
Oracle programming for starter 14 72
This is an explanation of a simple data model to help parse a JSON feed
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…

739 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