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 Multitier 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 Installing 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 for Windows
To access data from Excel
To access data from Access
6
Writing Macros to Access Data
6.1 Writing Macros
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 Macro
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
6.5
Guidelines and Samples
6.5 Guidelines and Samples
6.5.1 Word for
Windows
6.5.1 Word for Windows
To write a Word macro
6.5.2 Excel
6.5.2 Excel
To write an Excel macro
6.5.3 Access
6.5.3 Access
To write an Access macro
6.5.4
Canceling a Query
6.5.4 Canceling a Query
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.3 Summary of Dictionary Fields
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 AcuODBC Trace
Files
8.3 AcuODBC Trace Files
To initiate AcuODBC's Vision or SQL trace function
8.4
General ODBC Trace Files
8.4 General ODBC Trace Files
To initiate the Microsoft ODBC trace function
A
Installation
A.1
Single-Tier Installation
A.1 Single-Tier Installation
A.1.1 Hardware and
Software Requirements
A.1.1 Hardware and Software Requirements
To install AcuODBC in a single-tier environment
Remaining activities
A.2
Multiple-Tier Installation
A.2 Multiple-Tier Installation
B ODBC
Conformance Levels
B.1 ODBC Conformance Levels
B.2 SQL Conformance
B.3 API Conformance
Glossary of
Terms
Glossary of Terms
(c) Copyright Acucorp, Inc., 1988-1999. ALL RIGHTS RESERVED.