What Is Oledb And Odbc

The ole db conceptually divided into two sections.

What is oledb and odbc.

Microsoft ole db provider for odbc overview. Qlikview supports the ole db interface for connection to external data sources. On the other hand jdbc is platform independent and can be used for any platform. Odbc has expanded its compatibility with the use of drivers which is a major driving factor in the change of strategy by.

One opinion is that odbc is more specific and to the point where oledb is overly generic and over complicated. The main difference between odbc oledb and jdbc is that the odbc is an api developed by microsoft to access relational databases and oledb is an api developed by microsoft to access both relational and non relational databases while jdbc is an api developed by oracle to access the relational and non relational database. Odbc can be considered as a type of procedural as most of these drivers are developed in a native languages like c and c which are the procedural types of language. Sql s 2012 launch was the last to support oledb.

This skews the vote in favour of odbc. Odbc provides access only to relational databases and they are used by ole db to access sql based data sources. Ole db object linking and embedding database sometimes written as oledb or ole db an api designed by microsoft allows accessing data from a variety of sources in a uniform manner. To an ado or rds programmer an ideal world would be one in which every data source exposes an ole db interface so that ado could call directly into the data source.

Odbc is platform dependent as we can use odbc only for windows platform. 13 minutes to read 2. Odbc is a platform language and operating system independent interface that can be used for this purpose. There are exclusive providers for each type of data source supported by ole db.

Odbc open database connectivity and oledb object linking and embedding database are two interfaces that solve this specific problem. Consumers are the user applications that require the data and the providers are those who implement the apis and in turn fetch the required data from the data sources. A great number of external databases can be accessed via the microsoft ole db provider for odbc drivers. Qlikview odbc and oledb.

It is a standard api used to access database management systems. It is otherwise unrelated to ole microsoft originally intended ole db as a higher level replacement for and successor to. The api provides a set of interfaces implemented using the component object model com. Ole db and odbc ole db.