ACC95: Jet & ODBC White Paper Available in Download Center (128385)

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