|
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]
|