Microsoft KB Archive/128385

= ACC95: Jet & ODBC White Paper Available in Download Center =

Article ID: 128385

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q128385



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
The Jetdat1.doc white paper discusses the Microsoft Jet database engine version 3.0 and how it uses Open Database Connectivity (ODBC).

The following file is available for download from the Microsoft Download Center:

Download Rjwpv3.exe now

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.



MORE INFORMATION
This white paper contains the following topics:
 * Overview
 * ODBC API Usage
 * Configuration Options for ODBC Connectivity
 * Configuration Table
 * Background Population Settings
 * Disabling of Password Storage via the System Registry
 * System Registry Settings
 * Connection Management
 * Active Statements
 * Cursor Commit/Rollback Behavior
 * Connecting to SQL Server: An Example
 * Connection Sharing
 * Connections Caching/Aging
 * Authentication
 * Linking Tables
 * Unique Indexes ("Bookmarks")
 * Floating-Point Data in the Bookmark
 * Datatype Mapping
 * How ODBC Datatypes Are Mapped to Jet Types
 * How Jet Datatypes Are Mapped to ODBC Types
 * Specific Server Examples
 * Data Retrieval
 * Export (Make Table Queries)
 * Dynasets Vs. Snapshots
 * Result Set Population
 * Data Fetching
 * Performance Implications
 * Asynchronous Query Execution
 * Optimization of Find
 * SQL Pass-Through Queries
 * Integration of Pass-through Queries
 * Processing Multiple result sets
 * Modifying Server Data
 * Volatile Primary Keys
 * Columns Updated/Inserted
 * Security
 * Locking and Concurrency
 * Transactions
 * Performing Bulk Operations
 * Sending Queries to a Server
 * Identifying Remote Processing
 * Processing That Must Be Done Locally
 * Heterogeneous Joins
 * Operations Not Expressible in a Single SQL Statement
 * Operations Not Supported on the Server
 * Restriction Splitting
 * Evaluation of Outputs
 * Remote Execution of Crosstab Queries
 * Outer Joins
 * Generating SQL to Send to a Server
 * Wildcards for the LIKE Operator
 * Owner and Table Prefixing
 * Identifier Quoting
 * JET-to-ODBC SQL Tracing
 * ODBC Specification Compliance Errors

Additional query words: Rjwpv3 exe

Keywords: kbinfo kbdownload kbgraphxlinkcritical kbfile KB128385

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.