Link to home
Start Free TrialLog in
Avatar of visualbasic
visualbasicFlag for Ireland

asked on

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
Avatar of ameba
ameba
Flag of Croatia image

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.
Avatar of Éric Moreau
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).
Avatar of corvanderlinden
corvanderlinden

I fully agree with emoreau
ASKER CERTIFIED SOLUTION
Avatar of Kishore012000
Kishore012000

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Kishore:

That's not really an answer . . .

visualbasic:

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?

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

http://www.microsoft.com/data/ado/adotechinfo/dao2ado.htm