Microsoft Data Access Technical Articles Overview

These technical articles provide supplemental information about data access, usually including example code. Data access articles are divided into articles about Microsoft® Data Access Components (MDAC) in general, then about the component technologies Microsoft ActiveX® Data Objects (ADO) and OLE DB.

For links to articles with more general descriptions of these technologies and how they compare, see Microsoft Data Access Backgrounders Overview.

MDAC Articles

• “Designing Efficient Applications for Microsoft SQL Server,” available in the Platform SDK node.
  
  
• “Improve the Performance of Your MDAC Application,” available in the Platform SDK node.
  
  
• “Improving the Performance of the Data Access Components when Running with IIS 4.0,” available in the Platform SDK node.
  
  
• “Redistributing Microsoft Data Access Components,” available in the Platform SDK node.
  
  
• Rowset Persistence in MDAC
  
  
• What's New (and Improved) in Microsoft Data Access 2.0

ADO Articles

• A Class to Prepare Strings for Submission to a Database
  
  
• “ADO and RDS Security Issues in the Microsoft Internet Explorer,” available in the Platform SDK node.
  
  
• “ADO and SQL Server Developer's Guide,” available in the Platform SDK node.
  
  
• “ADO/WFC vs JDBC,” available in the Platform SDK node.
  
  
• “Extracting Error Information from ADO in Visual Basic,” available in the Platform SDK node.
  
  
• How Do I Use the Connection Object in ADO?
  
  
• Implementing ADO with Various Development Languages
  
  
• Remote Data Service in MDAC 2.1
  
  
• Using Microsoft ActiveX Data Objects via Visual Basic
  
  
• “Using the Customization Handler Feature in RDS 2.0,” available in the Platform SDK node.
  
  
• What Are the Objects in the ADO Object Model?
  
  
• What's New in ADO 2.0
  
  
• “Windows Foundation Classes for Java and ADO/WFC,” available in the Platform SDK node.

OLE DB Articles

• “Conformance Testing in OLE DB,” available in the Platform SDK node.
  
  
• “Mapping ADO Methods to OLE DB Interfaces,” available in the Platform SDK node.
  
  
• Microsoft OLE DB Provider for Oracle: Tips, Tricks, and Traps
  
  
• “OLE DB for the ODBC Programmer,” available in the Platform SDK node.
  
  
• “OLE DB Leveling,” available in the Platform SDK node.
  
  
• “OLE DB Sample Provider,” available in the Platform SDK node.