INFO: MDAC-Related White Papers (ODBC/OLE DB/ADO/RDS)

ID: Q190215

The information in this article applies to:

Microsoft Data Access SDK, versions 2.0, 2.1
Microsoft Data Access Components versions 1.5, 2.0, 2.1 SP2
Microsoft Open Database Connectivity, versions 3.0, 3.5, 3.51, 3.6, 3.7
Microsoft OLE DB, version 2.0
ActiveX Data Objects (ADO), versions 1.5, 2.0, 2.1 SP2
Remote Data Service for ADO versions 1.5, 2.0, 2.1 SP2

SUMMARY

This article contains a listing of white papers, newsgroups, and other resources that you may use for Microsoft Data Access Components (MDAC) technologies.

MORE INFORMATION

White Papers Included with the Microsoft Data Access Software Development Kit (SDK)

You can find them online at the following site:

http://msdn.microsoft.com/library/default.htm

Click show toc to display the Contents in a tree format in the left pane of your browser.

In the Contents tree, navigate to the following help topic:


\Platform SDK
    \Data Access Services
        \Microsoft Data Access SDK
            \Microsoft Data Access Technical Articles

Note that the Data Access SDK documentation is also available:

On the MSDN Library CDs, available with a MSDN subscription and in the Visual Studio documentation
For download. You may download the Data Access SDK from the following site on the World Wide Web:
http://www.microsoft.com/data/download.htm

Here are some recommended articles from the Microsoft Data Access Technical Articles. A quick summary of these articles follows. Each article is also rated with stars, (****) to indicate the technical depth of the article. Four stars is a very technical article that has lots of practical information or source code. One star indicates a high level overview, something you might see from marketing.

Universal Data Access Articles

Microsoft Strategy for Universal Data Access (*)

This article gives a high-level overview of Microsoft Universal Data Access.

Accessing Data from Multiple Sources with the Universal Data Access Technologies (**)

This article gives an overview with several diagrams that explain the Microsoft Universal Data Access.

Universal Data Access Q? (*)

This article answers many common questions on Universal Data Access.

Data Access Technologies Technical Articles

What's New (and Improved) in Microsoft Data Access 2.0 (**1/2)

A technical discussion examining the foundation of Universal Data Access as implemented within Microsoft Data Access Components 2.0, which includes ODBC 3.51, OLE DB 2.0, ADO 2.0, RDS 2.0.

Redistributing Microsoft Data Access Components (****)

This presents the grand vision of MDAC Redistribution, and details some of the problems along the way. Note that redistribution of MDAC components was greatly simplified when all of the components were combined into a single redistributable, MDAC_TYP.EXE. MDAC_TYP.EXE is available for download at:

http://www.microsoft.com/data/download.htm

NOTE: This white paper also presents a detailed explanation of the acronyms for MDAC technologies as well as which version of MDAC was shipped with a given Microsoft product.

ActiveX Data Objects (ADO) Technical Articles

What's New in ADO 2.0 (****)

Details new features in ADO 2.0. Lots of sample code.

Migrating from DAO to ADO (***)

Vital information for developers with a background in DAO who are considering moving to ADO.

ADO and SQL Server Developer's Guide (***)

Introduces ADO and how to use ADO' features with Microsoft SQL Server. Has many Visual Basic and Visual C++ code snippets.

Remote Data Service in MDAC 2.0 (****)

Details features in Remote Data Service (RDS) version 2.0 and later.

Implementing ADO with Various Development Languages (****)

Also known as the ADO Rosetta Stone. This white paper details the nitty gritty details of implementing ADO with Visual Basic for Applications (VBA, used in Visual Basic and Microsoft Access), C++ (via #import, MFC OLE, or COM API's), Java (Web Foundation Classes (WFC) Classes, Java Type Library Wizard or Microsoft Java SDK), Scripting (Visual Basic Script or JavaScript), and Visual FoxPro. A companion download includes 500K of (compressed) sample code.

OLE DB Technical Articles

Data Access to the Masses Through OLE DB (***)

Moderately detailed explanation of OLE DB and the most important COM Interfaces in OLE DB.

OLE DB Leveling: Choosing the Right Interfaces (***)

Invaluable for anyone creating an OLE DB Provider to expose data. This document is evolving, and you should check every few months for corrections and/or modifications.

OLE DB for the ODBC Programmer (****)

A favorite of product support professionals, this is a must-read for anyone using OLE DB, either to create a consumer or provider. The white paper focuses on creating a consumer, and is useful if you have not developed in ODBC.

Microsoft OLE DB Provider for Oracle: Tips, Tricks, and Traps (****)

Open Database Connectivity(ODBC) Technical Articles

Details the new Microsoft OLE DB Provider for Oracle, best practices for performance and which Oracle features are and are not supported by the provider.

Understanding ODBC and OLE (1/2)

A brief comparison of ODBC and OLE, leading up to the creation of OLE DB.

Understanding ODBC Security Issues (*1/2)

A very terse discussion referencing other materials treating ODBC Security.

Securing Windows NT to Prevent ODBC Tracing (**)

A brief discussion of the registry settings to use with Windows NT to prevent ODBC Tracing.

White Papers Outside of the Microsoft Data Access SDK

Universal Data Access through OLE DB (*)

High-level overview of OLE DB.

The Web site is:

http://www.microsoft.com/data/oledb/prodinfo/wpapers/wpapers.htm

Exploring ActiveX Data Objects 2.0 from an RDO 2.0 Point of View (****)

A useful roadmap for RDO developers.

The Web site is:

http://msdn.microsoft.com/vbasic/technical/articles/ado20/default.asp

REFERENCES

For additional information, please visit the Microsoft Universal Data Access Web site at:

http://www.microsoft.com/data

Additional query words: ado rds odbc oledb kbado210 kbado210sp2 kbrds210 kbrds210sp2 kboledb210 kboledb210sp2 kbsqlserver kbaccess kbprovider kbdatabase

Keywords : kbGrpVBDB kbGrpMDAC kbDSupport
Version : WINDOWS:1.5,2.0,2.1,2.1 SP2,3.0,3.5,3.51,3.6,3.7
Platform : WINDOWS
Issue type : kbinfo