>What is the difference bt OLEDB & ODBC.i know that both are for data connection.
>but OLEDB is a control.Pls let me know that,clear.Thanks for ur help.


OLE DB Overview

OLE DB, a set of interfaces for data access, is Microsoft's component database architecture that provides universal data integration over an enterprise's network— from mainframe to desktop— regardless of the data type. Microsoft's Open Database Connectivity (ODBC) industry-standard data access interface continues to provide a unified way to access relational data as part of the OLE DB specification. Over time, OLE DB is expected to lead new database products that are assembled from best-in-class components rather than from the monolithic products available today.

OLE DB provides a flexible and efficient database architecture that offers applications, compilers, and other database components efficient access to Microsoft and third-party data stores.

OLE DB is the fundamental Component Object Model (COM) building block for storing and retrieving records and unifies Microsoft's strategy for database connectivity. It will be used throughout Microsoft's line of applications and data stores.

OLE DB defines interfaces for accessing and manipulating all types of data. These interfaces will be used not just by data-consuming applications but also by database providers. By splitting databases apart, the resulting components can be used in an efficient manner. For example, components called service providers can be invoked to expose more sophisticated data manipulation and navigation interfaces on behalf of simple data providers.




ODBC Overview

ODBC is designed for maximum interoperability—that is, the ability of a single application to access different database management systems (DBMSs) with the same source code. Database applications call functions in the ODBC interface, which are implemented in database-specific modules called drivers. The use of drivers isolates applications from database-specific calls in the same way that printer drivers isolate word processing programs from printer-specific commands. Because drivers are loaded at run time, a user only has to add a new driver to access a new DBMS; it is not necessary to recompile or relink the application.




Basically....OLE DB is what you should use if you're developping in VB 6. ODBC is an older technology.