Difference between ODBC and OLEDB

Difference between ODBC and OLEDB


What is the difference between ODBC and OLEDB?

First, let us take a look at ODBC.

ODBC

ODBC stands for Open Data Base Connectivity, which is a connection method to data sources.

When connecting a tool or application to a database, a data source, also called a Database Source Name (DSN), using an SQL driver or other driver if connecting to other database type, needs to be set up.  Then, the application is connected to the database using this DSN.

DSN is a data structure used to describe a connection to a database. A DSN will take the form of a protocol: subprotocol: host: port:. Those are the parameters required to completely specify the connection. The exact format of the DSN will vary depending on your programming language.

ODBC is the method of connectivity that encompases the DNS. Most database systems support ODBC.

OLEDB

OLEDB stands for Object Linking and Embedding Database. It is an application programming interface designed by Microsoft for accessing different types of data stores in a uniform manner.

It is a newer and improved successor to ODBC.

OLEDB is the successor to ODBC, a set of software components that allow a "front end interface" such as a graphical user interface (GUI) based on VB, C++, Access, and others to connect with a back end such as SQL Server, Oracle, DB2, mySQL, etc.

OLEDB components in many cases offer improved performance over the older ODBC.

OLEDB is a different type of data provider that came about with MS's Universal Data Access in 1996.

OLEDB does not require a DSN.

Additional information

More information can be found at the Microsoft website:

            http://www.microsoft.com/data

.

Discuss this article or this topic in our discussion forum:
(The table bellow shows a list of 8 most recent topics posted in our discussion forum. Visit our discussion forum to see more. It is possible the links below are not related to this page, but you can be certain you will find related posts in the discussion forum. You can post one yourself too.)
Email this article to a friend:
TO: 
FROM: 
2 + 6 - 3 = 
.
How can I link to this web page?

It is easy, just include the code provided below into your HTML code.

<a href="http://www.maxi-pedia.com/What+is+the+difference+between+ODBC+and+OLEDB" title="www.Maxi-Pedia.com: Difference between ODBC and OLEDB" target="_blank">Difference between ODBC and OLEDB</a>
.