OLE DB Samples

OLE DB Samples

The following OLE DB samples are available for this release.

Rowset Viewer Sample

The Rowset Viewer sample provides a simple way to view and manipulate rowsets. Because Rowset Viewer has been expanded to include much of the functionality of the Query Demo sample, Query Demo has been removed. To run the Rowset Viewer sample, click Start, point to Programs, point to Platform SDK, point to Data Access, and click RowsetViewer.

File name Description
RowsetViewer.exe Rowset Viewer sample

For information about building and running the Rowset Viewer sample, see Rowset Viewer Sample.

Table Copy Sample

The Table Copy sample demonstrates a simple consumer that reads data from one OLE DB rowset and saves it as a new table. To run the Table Copy sample, click Start, point to Programs, point to Platform SDK, point to Data Access, and click Table Copy.

File name Description
TableCopy.exe Table Copy sample

For information about building and running the Table Copy sample, see Table Copy Sample.

Sample Consumer

The sample consumer demonstrates how to build a simple consumer. This consumer uses the sample provider. To run the sample consumer, click Start, point to Programs, point to Platform SDK, point to Data Access, and click Sample Client For Text Provider.

File name Description
SampClnt.exe Sample consumer

For information about building and running the sample consumer, see OLE DB Sample Consumer.

OLE DB Sample Provider

The OLE DB Sample Provider demonstrates the construction of a very simple OLE DB provider. This sample is intended as a learning tool for developers new to writing OLE DB providers. The sample provider exposes data in a single, comma-separated value file named CUSTOMER.CSV.

The source files are located in the SAMPLES\DATAACCESS\OLEDB\SAMPPROV folder of the Microsoft Platform SDK installation folder. Only the source code and project files are included for the sample provider. To build the executable provider, either run NMAKE on the SampProv.mak file or load the project into the Microsoft® Visual C++® development environment and compile it.

ATL OLE DB Provider

OmniProv 1.0 is an ATL OLE DB Provider sample that works with the Microsoft DataGrid Control 6.0 (OLE DB) and the Microsoft ADO Data Control 6.0 (OLE DB) using server-side cursors. It has the capability of supporting nondeferred updates, inserts, and deletes. Additionally, it implements a storage class, which interfaces with a custom database. The ATL OLE DB Provider sample is part of the Data Access MSDN Technical Articles and can be located at http://msdn.microsoft.com/library/techart/omniprov.htm.