1 Introduction
1.1 Overview
1.2 Product Requirements
1.3 What is ODBC?
1.4 Front- and Back-end ODBC
1.5 Technical Support
2 AcuODBC Architecture
2.1 AcuODBC Design
2.2 AcuODBC Single-Tier
2.2 AcuODBC Single-Tier
2.2.1 Single-tier Components
2.3 AcuODBC Multiple-Tier
2.3 AcuODBC Multiple-Tier
2.3.1 Multi-tier Components
3 Creating Data Source Names
3.1 Data Source Names (DSNs)
3.1 Data Source Names (DSNs)
To add a data source name
To modify data source parameters
To delete a data source name
3.2 Advanced Options
3.2 Advanced Options
3.3 Multi-Company Support
3.3 Multi-Company Support
To manage multi-company files
3.4 Vision Options
3.4 Vision Options
4 AcuODBC Sample Program
4.1 Locating the Sample Program
4.2 The Sample Orders Program
4.3 How the Sample Orders Program Works
4.4 The Sample Data Source Name
4.4 The Sample Data Source Name
To create the sample DSN
4.5 Running the Query Sample Program
4.5 Running the Query Sample Program
To run the query sample program
5 Working with Windows Applications
5.1 Working With Windows Applications
5.1 Working With Windows Applications
To access data from Word 2000
To access data from Word for Windows Version 7.0
To access data from Excel 2000
To access data from Excel Version 7.0
To access data from Access 2000
To access data from Access Version 7.0
6 Writing Queries to Access Data
6.1 Writing Queries
6.2 What To Consider
6.2 What To Consider
6.2.1 COBOL vs. Application Language
6.2.2 How Relational Databases Organize Data
6.2.3 Troubleshooting Your Program
6.3 SQL Syntax Supported by AcuODBC
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
6.3.2 INSERT Command
6.3.3 DELETE Command
6.3.4 UPDATE Command
6.3.5 The AcuODBC Optimizer
6.4 SQL Reserved Words Supported by AcuODBC
6.4 SQL Reserved Words Supported by AcuODBC
7 Data Dictionaries
7.1 Data Dictionaries
7.2 XFD Files
7.2 XFD Files
7.2.1 How the Data Dictionary is Formed
7.2.2 Defaults Used in XFD Files
7.2.2 Defaults Used in XFD Files
7.2.2.1 Examples
7.2.3 Summary of Dictionary Fields
7.2.3 Summary of Dictionary Fields
7.2.4 Naming the XFD
7.2.4 Naming the XFD
7.3 Using Directives
7.3 Using Directives
7.3.1 Syntax
7.3.2 AcuODBC Hidden Directive
7.3.3 AcuODBC Read-Only Directive
7.3.4 Date Directive
7.3.5 File Directive
7.3.6 Name Directive
7.3.7 Numeric Directive
7.3.8 Use Group Directive
7.3.9 When Directive
7.4 How AcuODBC Locates XFD Files
7.4 How AcuODBC Locates XFD Files
8 Troubleshooting
8.1 Overview of Errors
8.2 Native Vision Errors
8.3 Application Errors
8.4 AcuODBC Trace Files
8.4 AcuODBC Trace Files
To initiate AcuODBC's Vision or AcuODBC trace function
8.5 General ODBC Trace Files
8.5 General ODBC Trace Files
To initiate the Microsoft ODBC trace function
A ODBC Conformance Levels
A.1 ODBC Conformance Levels
A.2 SQL Conformance
A.3 API Conformance
Glossary of Terms
Glossary of Terms
(c) Copyright Acucorp, Inc., 1996-2000. ALL RIGHTS RESERVED.
The software is protected by the following copyright: (c) 1996-2000 Maxway Consulting Ltd.