Microsoft KB Archive/190215

{|
 * width="100%"|

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

 * }

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, 2.5, 2.6
 * Microsoft Open Database Connectivity, versions 3.0, 3.5, 3.51, 3.6, 3.7
 * Microsoft OLE DB, versions 2.0, 2.1, 2.5, 2.6
 * ActiveX Data Objects (ADO), versions 1.5, 2.0, 2.1 SP2, 2.5, 2.6
 * Remote Data Service for ADO versions 1.5, 2.0, 2.1 SP2, 2.5, 2.6
 * Microsoft Platform Software Development Kit (SDK) January 2000 Edition

-

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

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"