OLE DB Definitions
OLE DB is Microsoft's data interface.
It can work with most any data format.
OLE DB can work with data from:
* All major databases such as SQL Server, Oracle and MS Access.
* Excel spreadsheet data.
* Text files.
* Web data and Email data.
* Others
Data Stores
A Data Store refers to any data that can be accessed through OLE DB.
Data Providers
A Data Provider is a program written to interface with a Data Store.
A Data Provider can transform the raw data into a row/column format
that can be used by a program.
Most Data Providers also provide for data manipulation, using tools such as SQL.
Some common data providers:
| Microsoft.Jet.OLEDB.4.0 | Jet databases like MS Access |
| MSDASQLMicrosoft OLE DB Provider for SQL Server | For SQL Server databases |
| Microsoft OLE DB Provider for Oracle | For Oracle databases |
| Microsoft OLE DB Provider for ODBC Drivers | For Excel sheets and Text Files |
Data Consumers
A Data Consumer is a software program that communicates with a Data Store.
The Data Consumer sees all data in a row - column format.
Copyright © 2006-2019, LQSystems,Inc. All rights reserved.
