OLE DB
Home > SQL Server Definitions - OLE DB
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

OLE DB



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

DEFINITION - OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. OLE DB includes not only the Structured Query Language (SQL) capabilities of the Microsoft-sponsored standard data interface Open Database Connectivity (ODBC) but also includes access to data other than SQL data.

As a design from Microsoft's Component Object Model (COM), OLE DB is a set of methods (in earlier days, these might have been called routines) for reading and writing data. The objects in OLE DB consist mainly of a data source object, a session object, a command object, and a rowset object. An application using OLE DB would use this request sequence:

  1. Initialize OLE.
  2. Connect to a data source.
  3. Issue a command.
  4. Process the results.
  5. Release the data source object and uninitialize OLE.

OLE once stood for "Object Link Embedding" and "DB" for database. However, Microsoft no longer ascribes these meanings to the letters "OLE" and "DB."

LAST UPDATED: 10 Jul 2006

Read more about OLE DB:
- OLE DB for the ODBC Programmer explains the relationship between OLE DB and ODBC.
- SearchVB.com, a portal for Visual Basic developers, includes a collection of links about OLE DB.


Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SQL Server data conversions from date/time values to character types
Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and...
SQL and SQL Server Tutorial and Reference Guide
This Back to Basics SQL tutorial and reference guide provides a great starting point and foundation for learning SQL or brushing up on your skills.
How to use the SELECT statement in SQL
Learn the SQL SELECT statement and how to use its many keyword clauses in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
ACID  (SearchSQLServer.com)
commit  (SearchSQLServer.com)




HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts