OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing data from a variety of sources in an uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed 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.

OLE 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. MDAC is a group of Microsoft technologies that interact together as a framework that allows programmers a uniform and comprehensive way of developing applications for accessing almost any data store.

Microsoft's 'Denali' release of SQL server will be 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.


See also

Wikimedia Foundation. 2010.

Look at other dictionaries:

  • ole — ole·a·ce·ae; ole·a·ceous; ole·a·ci·na; ole·a·cin·i·dae; ole·ag·i·nous; ole·ag·i·nous·ly; ole·ag·i·nous·ness; ole·a·les; ole·an·der; ole·an·drin; ole·a·no·lic; ole·ar·ia; ole·as·ter; ole·ate; ole·fi·ant; ole·fin; ole·fin·ic; ole·ic; ole·if·er·ous; …   English syllables

  • Öle — (Olĕa, Chem.). A) Ätherische Öle (Flüchtige Öle), sind Flüssigkeiten organischen Ursprungs, welche sich durch einen durchdringenden, theils höchst angenehmen, theils widrigen Geruch, durch gewürzhaften, brennenden Geschmack u. durch ihre… …   Pierer's Universal-Lexikon

  • olé — [o lɛ] <Interj.> [span. olé < arab. wa llāh(i) = bei Gott]: span. Ausruf mit der Bed. los!; auf!; hurra! * * * OLE   [Abk. für Object Linking and Embedding, dt. »Verknüpfen und Einbetten von Objekten«] …   Universal-Lexikon

  • OLE — OLE, Ole or Olé may also refer to: Ole (name), a male given name, includes people named Ole Object Linking and Embedding, a distributed object system and protocol developed by Microsoft OLE Automation, an inter process communication mechanism… …   Wikipedia

  • OLE — Cette page d’homonymie répertorie les différents sujets et articles partageant un même nom. {{{image}}}   Sigles d une seule lettre   Sigles de deux lettres > Sigles de trois lettres …   Wikipédia en Français

  • olé — [ ɔle ] ou ollé [ ɔ(l)le ] interj. • 1919; esp. ole 1 ♦ Exclamation espagnole qui sert à encourager. Le public crie olé à chaque passe de la corrida. 2 ♦ Adj. inv. Fam. OLÉ OLÉ [ ɔleɔle ]. Qui est libre dans ses manières ou son langage; égrillard …   Encyclopédie Universelle

  • OLE DB — (англ. Object Linking and Embedding, Database)  набор интерфейсов, основанных на COM, которые позволяют приложениям обращаться к данным, хранимым в разных источниках информации или хранилищах данных с помощью унифицированного доступа.… …   Википедия

  • Öle — (von lat. oleum, aus altgr. ἔλαιον ,Olivenöl‘) ist eine Sammelbezeichnung für Flüssigkeiten, die sich nicht mit Wasser mischen lassen. Inhaltsverzeichnis 1 Gruppen von Ölen 1.1 Fette Öle 1.2 Ätherische Öle …   Deutsch Wikipedia

  • OLE DB — (algunas veces escrito como OLEDB u OLE DB) es la sigla de Object Linking and Embedding for Databases ( Enlace e incrustación de objetos para bases de datos ) y es una tecnología desarrollada por Microsoft usada para tener acceso a diferentes… …   Wikipedia Español

  • OLE — steht für Ole (Vorname), männlicher Vorname, skandinavische Nebenform von Olaf, plattdeutsche (=niederdeutsche) Form für der Alte im Sinne von der Erstgeborene Olé, spanischer Ausruf Ole, in Mandarin: Ou.Le Die Freude aus Europa Die Abkürzung OLE …   Deutsch Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.