Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 128385 - Last Review: January 26, 2005 - Revision: 2.3
ACC95: Jet & ODBC White Paper Available in Download Center
This article was previously published under Q128385
Moderate: Requires basic macro, coding, and interoperability skills.
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:
Collapse this imageExpand this image
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=119591/EN-US/
)
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.
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
APPLIES TO
- Microsoft Access 95 Standard Edition
| kbdownload kbfile kbgraphxlinkcritical kbinfo KB128385 |
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate