The Microsoft Data Access SDK is the primary source of information and instruction on using data access technologies. Its tools, samples, and documentation are designed to help developers create solutions for data access needs.
The SDK also contains tools and information for developing OLE DB providers, ODBC drivers, ADO, RDS, and, headers and libs for Visual C++ developers. For the latest news and updates on the data access technologies go to our website at www.microsoft.com/data.
If you're installing the SDK from Visual Studio, the documention for the SDK is in the MSDN CD, installed by Visual Studio. There are help files and other documentation in \msdasdk\doc directory.
If you are installing the standalone version of the SDK, the documentation is installed directly with the SDK. You can access it from the Start menu in the Data Access SDK program group.
Setup installs the files in the following directories on your disk. These are subdirectories of the default installation directory \Msdasdk.
Directory | Description |
bin | Binary files for all SDK components |
conformance | Tests to run on your provider/driver to prove conformance to OLE DB Standards |
doc | Documentation and Help file directory |
HookOLE | HookOle files for use by OLE DB Spy |
include | Header files for SDK components |
lib | Library files for SDK components |
misc | Miscellaneous file |
redist | Redistributable files |
samples | Subdirectories containing source for all samples |
testmod | QuikTest module files which provide a useful overview of provider functionality |
unsupported | Unsupported files |
Subdirectory | Description |
ado | ActiveX Data Objects specific files |
oledb | OLE DB specific files |
odbc | Open Database Connectivity specific files |
osp | OLE DB Simple Provider Toolkit specific files |
mdac | Microsoft Data Access Components specific files |
rds | Remote Data Service specific files |
acw | ActiveX Control Writer Toolkit files |
The following samples are included:
Online Catalog Application Sample
Demonstrates a three-tier Web application. The application uses any standard HTML browser. The server side uses Active Server Pages to format the output and for order placement and inquiry.
GetRows Sample
A C/C++ sample that demonstrates the use of the Recordset object's GetRows method to retrieve all the rows of a rowset into a 2-dimensional array.
Employee Sample
Displays data in a form that allows you to scroll, insert,update and delete data.
ADORead Sample
A C/C++ sample that generates timings for fetching data using different cursor types and cache sizes.
ADOasp Sample
An Active Server Pages sample that lets clients browse through components and obtain data.
ADOISAPI Sample
A C/C++ ISAPI extension sample that establishes a cached connection to a database, fetched data, formats the data as an html table.
ADOjava Sample
A Visual J++ sample that demonstrates Java/COM integration.
ADOvbs
A VBSrcipt sample that builds a 2-tier application for an intranet.
Query Demo Sample
Demonstrates how to build a consumer capable of issuing queries.
Rowset Viewer Sample
Provides a simple way to view and manipulate rowsets.
Table Copy Sample
Demonstrates a simple consumer that reads data from one OLE DB rowset and saves it as a new table.
Sample Consumer
Demonstrates how to build a simple consumer.
OLAP client applications Sample
Demonstrates working with any multidimensional data provider exposing OLE DB for OLAP interfaces and includes a provider with sample Olap multidimensional database (BobsVideo.cub) to query.
Admin Demo Sample
Demonstrates how to connect to a data source, execute SQL statements, run scripts, and perform other special tasks. It can list information (such as data types, functions, and general ODBC information) about the data source being used.
Cursor Demo Sample
Demonstrates the block cursor, scrolling, positioned update, and delete capabilities of the ODBC Cursor Library.
Query Demo Sample
Demonstrates multiple simultaneous connections.
Convert DSN Demo Sample
Demonstrates how to convert User and System DSNs to File DSNs.
The DA SDK contains the following 32-bit ODBC data sources:
This data source points to the NorthWind Access database shipped with the DA SDK. This is \msdasdk\bin\oledb\nwind.mdb.
This data source points to the Microsoft SQL Server "pubs" database. The server is set to "." and the database name is set to "pubs". You may need to modify this data source to use it on your system.