Wednesday, September 22, 2004

Difference between ODBC and OLEDB

First of all both are API for database access.
The differences between these two data access protocols are technical, but in the most general terms, OLE DB is newer, more advanced, and compatible with a wider selection of database technologies. In addition, OLE DB is more general, in that it includes the ODBC functionality.

Technically speaking, ODBC (Open Database Connectivity) is designed to provide access primarily to SQL data in a multi-platform environment. OLE DB (Object Linking and Embedding Database) is designed to provide access to all types of data in an OLE Component Object Model (COM) environment. OLE DB includes the SQL functionality defined in ODBC but also defines interfaces suitable for gaining access to data other than SQL data.

you can vist this page for details http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnodbc/html/msdn_ole4odbc.asp.

0 Comments:

Post a Comment

<< Home