Difference betwwen ADO vs ODBC vs OLE DB

Hi all,
=20
Well I could solve the problems mentioned before and could run the
application using ADO's.
But I am not clear on the difference between these ADO, ODBC and OLE
DB.
How these three are related to each other?? Are these three independent
or different methods to access the database or dependent of each other?
I am confused with these....
Please help me in clearing it out.
Please send details for it....
=20
Thanks in advance.
=20
Regards,
Sateesh. =20
=20
=20
=20

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: Difference betwwen ADO vs ODBC vs OLE DB

--=======6F562898=======
Content-Type: text/plain; x-avg-checked=avg-ok-47B7AB2; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

At 11:29 11/12/2003 +0530, Sateesh B. Kumar wrote:
Hi,

>Hi all,
>
>Well I could solve the problems mentioned before and could run the
>application using ADO's.
>But I am not clear on the difference between these ADO, ODBC and OLE
>DB.
>How these three are related to each other?? Are these three independent
>or different methods to access the database or dependent of each other?
>I am confused with these....
>Please help me in clearing it out.
>Please send details for it....

I suggest you for to download and install the MDAC SDK from
Microsoft for to know the details about them.


--=20
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil

--=======6F562898=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-47B7AB2
Content-Disposition: inline


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 2/12/2003


--=======6F562898=======
Content-Type: text/plain; charset=us-ascii

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
--=======6F562898=======--

Re: Difference betwwen ADO vs ODBC vs OLE DB

ADO is an application library. Basically a set of classes that let you interact with many different data sources using the same (nearly) code regardless of the data source. ODBC and OLEDB are data source interface drivers. These operate on a lower level then ADO.

Like this:

Application --> ADO --> ODBC --> Database

Using this kind of scheme lets you change one of the layers without changing the others (usually).

ODBC is older than OLEDB but is an Industry standard supported by almost everybody. OLEDB is Microsoft only. OLEDB does come with an interface driver itself so you could do the following if you had to.

Application --> ADO --> OLEDB --> ODBC --> Database

If you are using a language that has a direct API then you would be etter off using it as there will be less between you and your data.

Application --> API --> Database

You will get better performance but porting your code to a different data source or programming language would be harder.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Difference between ADO vs ODBC vs OLE DB

ADO = API to OLE DB.
ADO Speed < OLE DB Speed
Programming the OLE DB API Directly may take a very long time to master.

Explanation from M$.
ActiveX Data Objects (ADO) is a high-level, easy-to-use interface to OLE DB.
OLE DB is a low-level, high-performance interface to a variety of data
stores.
ODBC is another low-level, high-performance (maybe not-so high-performance,
I think) interface that is designed specifically for relational data stores.

ADO provides a layer of abstraction between your client or middle-tier
application and the low-level OLE DB interfaces. ADO uses a small set of
Automation objects to provide a simple and efficient interface to OLE DB.
This interface makes ADO the perfect choice for developers in higher level
languages, such as Visual Basic and VBScript, who want to access data
without having to learn the intricacies of COM and OLE DB.

A Note on Providers from M$:
You are strongly encouraged to use one of the native OLE DB Providers
instead of the Microsoft Open Database Connectivity (ODBC) Provider. Native
OLE DB Providers provide better application stability and performance.

If you want more info, go to http://msdn.microsoft.com/data
Then drill down from "Data Access->Reference.

HTH, Matt
---
Outgoing mail is certified Virus Free.
Regards, Matt
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org