ADO <-> OLEDB difference

[guenter]

Please, could someone explain me the main-differences between these two technologies.
Do they have the same root-objects ?
I started DB-programming using ODBC classes; what are the benefits using ADO, OLEDB ?

Any help is appreciated !
thanks
Guenter [sig]<p>guenter<br><a href=mailto:guenter.porzer@oekb.co.at>guenter.porzer@oekb.co.at</a><br>[/sig]

 

[Karl Blessing]

ADO is a much easier approach to database programming, it uses ODBC underneath, but is much more easier on the surface, look at my FAQ in the VC++ Forum regarding, how to get ADO to work in VC++, you'll notice the difference right off, if you have ever had to do OLEDB. [sig]<p>Karl<br><a href=mailto:kb244@kb244.com>kb244@kb244.com</a><br><a href=

http://kb244.com>

</a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>

http://www.brainbench.com/transcript.jsp?pid=629151

[/sig]

 

[AWEinCA]

Great question Guenter!

What about performance? Does ADO slow things down?

Aaron

 

[Cagliostro]

the fastest usualy is ODBC. Faster can be sometimes DAO. The fastest always is native API. About the performance for OLEDB/ADO, they lose performance only at procedure interpreting/compilling and connection/disconnection time, but it is not an issue then there are megabytes of data, because the driver has the main role in processing data. John Fill

ivfmd@mail.md