Sabtu, 09 Juni 2018

Sponsored Links

The 'Microsoft Jet OLEDB 4 0' provider is not registered on the ...
src: i.ytimg.com

OLE DB ( Connecting and Embedding Objects, Database , sometimes written as OLEDB or OLE-DB ), an API designed by Microsoft, allows accessing data from multiple sources in a uniform way. The API provides a set of interfaces that are implemented using Component Object Model (COM); it is not related to OLE. Microsoft originally intended OLE DB as a higher-level replacement for, and its successor, ODBC, expanded the feature set to support a wider range of non-relational databases, such as object databases and spreadsheets that do not always implement SQL.


Video OLE DB



Methodology

OLE DB separates data storage from applications that require access through a series of abstractions that include data sources, sessions, commands, and rowsets. This is done because different applications require access to different types and data sources, and do not always want to know how to access functionality with specific technology methods. OLE DB is conceptually divided into consumer and provider . Consumers are applications that require access to data, and the provider is a software component that implements the interface and thus provides data to the consumer. The OLE DB is part of the Microsoft Data Access Components (MDAC) stack.

Maps OLE DB



Support status

The release of Microsoft SQL Server 2012 (internal code: 'Denali') is the last one to include the OLE DB provider for SQL Server, but support will continue for 7 years. According to a related Microsoft FAQ, "Providers like ADO.NET that can run on top of OLE DB will not support OLE DB after the last one is no longer used", but the same answer in the FAQ states that the original post only relates to the OLE DB Provider for SQL Server , so the position of OLE DB itself is still unclear. The same FAQ states that ODBC performs better than OLE DB in most cases.

On October 6, 2017 Microsoft announced that the OLE DB was not terminated.

Advanced C# Tutorial 19 2 Project1 Create OleDb Connection in C# ...
src: i.ytimg.com


See also

  • OLE DB provider
  • OLE DB Consumer

0391 â€
src: nakulvachhrajani.files.wordpress.com


References

Source of the article : Wikipedia

Comments
0 Comments