Does ADO replace the need for ODBC? 1

[jeanpierre]

I am puzzled on when to use ODBC and ADO. Does ADO support all ODBC functions and more?

Thanks

 

[MapMan]

Here's an excerpt from an article by Microsoft that might shed some light on your question:

Open Database Connectivity (ODBC), is an international standard for manipulating relational data using SQL query syntax across disparate datasources. ODBC has the advantage of being an international standard that allows you to manipulate a vast array of relational datasources through numerous ODBC Drivers from both Microsoft and third party vendors. The key disadvantage of ODBC is that it is limited to relational, SQL-syntax based data.

ActiveX Data Objects(ADO), is Microsoft's strategic, language-neutral, high-level interface to data exposed by OLE DB. ADO provides consistent, high-performance access to data, whether you are creating a front-end database client or middle-tier business object using an application, tool, language, or even an Internet browser. ADO is the single data interface you need to know for 1 to n-tier client/server and Web-based data-driven solution development. ADO is the definitive OLE DB Consumer, although you could write your consumer application using C++ directly to a OLE DB provider.

For the full article, please see

[URL unfurl="true"]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q190463[/URL]

HTH, MapMan

Assume nothing, question everything, be explicit not implicit, and you'll always be covered.

 

[PhilX]

MapMan, that was interesting and informative. It also didn't come close to answering Jeanpierre's (and my) question.

 

[EugenePaliev]

ODBC is a bridge between your application and any DB that supports ODBC (currently most DB support it) - you can easily connect to MS SQL Server, Oracle, DB2, Access and others. It's a bridge. The main advantage of ODBC that it is a vendor independent bridge between your applications and the databases.

ADO is a tool to manipulate data. ADO may use OLE DB provider to connect to DB. It may also use ODBC to connect to DB. ADO is not a tool to connect to DB but to work with it! You may use ADO to manipulate data and ODBC to coonect to a DB at the same time working together. Good Luck!

 

[EugenePaliev]

So the main point is that you don't need to use ODBC and moreover droping ODBC is going to give you faster access because you don't have to go through the ODBC driver. Good Luck!