Home >> Computers >> Programming >> Databases >> OLE DB




OLE DB (for even instance written when OLEDB or OLE-DB) occurs as means Microsoft use for accessing different types of data stores in the uniform manner. Microsoft develop seperated a information store from either a application that needs access it through the utilise of this technology: this was done because different applications require access to different types & sources of information & don't necessarily obviously understand training access functionality by using technology-specific methods. OLE DB is conceptually divided into consumers & providers. A consumers come a applications that require access to a information, & the provider is the software system component that exposes an OLE DB interface through the apply of the Component Object Model (or COM).

OLE DB is a share of the MDAC (Microsoft Data Access Components) fold & is the database access interface technology. MDAC occurs as class action of Microsoft technologies that allow interact together as the framework that allows coder a uniform & comprehensive way of getting applications for accessing virtually any information store. OLE DB providers may be created to access such elementary information places as a document or even spreadsheet, through to such complex databases when Oracle and SQL Server. But, because different information store technology could use different capabilities, OLE DB providers might not implement each conceivable interface available to OLE DB. the capabilities that come available come implemented through a utilise of COM objects - an OLE DB provider may map the information store technologies functionality to a particular COM interface. Microsoft calls a handiness of an interface to exist as "provider-specific" when it might not exist as applicable based on the database technology included. In addition, all the same, providers could besides augment the capabilities of a information store - these capabilities come referred to as services inside Microsoft idiom.

OLE DB Providers
[http://msdn.microsoft.com/data/ Microsoft] ships two or three OLE DB Providers when section of its MDAC & Sooty kits [http://uda.openlinksw.com/oledb/ OpenLink Software] ships OLE DB Providers for the total of SQL DBMS, when well as OLE DB Bridges to ODBC and JDBC [http://www.sqlsummit.com/oledbVen.htm SQLSummit.com: Catalogue of OLE DB Providers]

Microsoft OLE DB
OLE DB is Microsoft's low-level application programming interface to access all kinds of data. ADO provides consistent, high-performance access to data. (Microsoft)

Sequiter OLE DB Consulting
Sequiter Software's Consultants can help you design, customize or optimize a custom OLE DB provider to access your data.

HTMProvi
An OLE DB Provider for HTML tables. It reads, writes and creates HTML tables. HTMProvi supports the most important OLE DB interfaces, schemas and SQL commands. By T.K Software. [Commercial]

OLE DB Leveling: Choosing the Right Interfaces
Discusses the minimum provider interfaces that must be supported as well as the optional providers interfaces when developing an OLE DB provider. (Microsoft)

OLE DB for the ODBC Programmer
Presents an introduction to OLE DB programming aid ODBC programmers in understanding and using OLE DB. (Michael Pizzo and Jeff Cochran / Microsoft)

OpenAccess OLE DB SDK
Provides the toolkit and the run-time software components needed to implement an OLE DB provider for your data source. By Automation Technology, Inc.

SimbaProvider for OLAP
An SDK and MDX Engine for developing OLE DB for OLAP (ODBO) providers to access proprietary OLAP data stores. It currently supports Win32 platforms. By Simba Technologies.

List of OLE DB Providers
Directory of authors and vendors of OLE DB provider software and OLE DB provider SDKs.


Computers: Programming: Component Frameworks: COM: Components: Database
Computers: Programming: Languages: Visual Basic: Databases





© 2005 GeneralAnswers.org