Wht have i had so many problems with ADO

I have just migrated for using Dao data access to ADO.I have had so many problems with ADO it's not funny.Could it just be a bad run or am I doing something.If anybody is using ADO full time could the help to Reassure me about its merits.
Regards T
Who is Participating?
Kishore012000Connect With a Mentor Commented:
   This is the advantage ADO has with DAO
ADO is designed as an easy-to-use application level interface to Microsoft's newest and most powerful data access paradigm, OLE DB. OLE DB provides high-performance access to any data source, including relational and non-relational databases, email and file systems, text and graphics, custom business objects, and more. ADO is implemented for minimal network traffic in key Internet scenarios, and a minimal number of layers between the front-end and data source — all to provide a lightweight, high-performance interface. ADO is called using a familiar metaphor — the OLE Automation interface. And ADO uses conventions and features similar to DAO and RDO, with simplified semantics that make it easy to learn.

Megasoft Limited
ADO is not mature yet.
I use both ADO and DAO in my projects so I can swith by changing single conditional directive (ADO=1 / ADO=0). I distribute only DAO version to customers for now - it is also faster on MDB database.
Éric MoreauSenior .Net ConsultantCommented:
I use ADO full time since a little more than a year now and I don't want to go back to DAO and/or RDO.

What kind of problem do you have? Do you know that, since it is not "Mature" yet, you have to download SP from time to time (www.microsoft.com/data).
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I fully agree with emoreau

That's not really an answer . . .


Switching from DAO to ADO can be problematic at best, and sometimes it causes so many problems you might want to just rewrite the data access portions of your app.  

What kinds of problems are you having?

Here's another URL to check out on this topic:

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.

All Courses

From novice to tech pro — start learning today.