Installing the Data Access SDK

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.

Directory Structure

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

SDK Samples

The following samples are included:

MDAC Sample

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.

ADO Samples

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.

OLE DB Samples

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.

ODBC Samples

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.

Predefined ODBC Data Sources

The DA SDK contains the following 32-bit ODBC data sources:

OLE_DB_NWind_Jet

This data source points to the NorthWind Access database shipped with the DA SDK. This is \msdasdk\bin\oledb\nwind.mdb.

OLE_DB_NWind_SQL

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.