| 词条 | OLE DB |
| 释义 |
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. The API provides a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. Microsoft originally intended OLE DB as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL. MethodologyOLE DB separates the data store from the application that needs access to it through a set of abstractions that include the datasource, session, command, and rowsets. This was done because different applications need access to different types and sources of data, and do not necessarily want to know how to access functionality with technology-specific methods. OLE DB is conceptually divided into consumers and providers. The consumers are the applications that need access to the data, and the providers are the software components that implement the interface and thereby provides the data to the consumer. OLE DB is part of the Microsoft Data Access Components (MDAC) stack. Support statusMicrosoft's release of SQL Server 2012 (internal code: 'Denali') is the last to include an OLE DB provider for SQL Server, but support will continue for 7 years.[1] According to a related Microsoft FAQ,[2] "Providers like ADO.NET which can run on top of OLE DB will not support OLE DB once the latter is deprecated", but the same answer in the FAQ states that the original post relates only to the OLE DB provider for SQL Server, so the position of OLE DB itself remains unclear. The same FAQ states that ODBC performs better than OLE DB in most cases. On Oct 6, 2017 Microsoft announced that OLE DB was undeprecated. [3] See also{{Portal|Microsoft|Software}}
References1. ^Microsoft SQLNCli team blog: Microsoft is Aligning with ODBC for Native Relational Data Access {{Microsoft APIs}}2. ^SQL Server Forums - SQL Server Data Access: Microsoft is Aligning with ODBC for Native Relational Data Access 3. ^ [https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/ Microsoft SQLNCli team blog: Announcing the new release of OLE DB Driver for SQL Server] 3 : Database APIs|Microsoft application programming interfaces|SQL data access |
| 随便看 |
|
开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。