AcuODBC User's Guide
2.1 AcuODBC Design
Open Database Connectivity (ODBC), developed by Microsoft, is the standard way to connect Windows applications to relational and non-relational databases. To submit a request to a database, ODBC-enabled applications use Structured Query Language (SQL).
There are three main ways to generate SQL commands from Windows applications:
- By invoking Microsoft Query and navigating through menus to submit a request. Query then generates SQL commands transparently.
- By writing SQL directly (without menus) in Microsoft Access. This interface uses the Microsoft Jet Database Engine.
- By writing application-specific programs. For instance, in Microsoft Word, you can generate SQL commands by writing WordBasic programs. In Microsoft Excel, you can use Excel/Visual Basic. This approach provides more flexibility, but requires programming expertise and is for advanced users only.
The AcuODBC® interface is designed to let Windows users read and write ACUCOBOL(TM)-GT's Vision files as well as relative files. Since none of these file formats is relational, AcuODBC's job is to receive ODBC calls from ODBC-enabled applications (like Microsoft Word) and translate them into the appropriate I/O actions.
After AcuODBC translates the ODBC calls into Vision I/O, it processes these requests for data and returns results to the driver manager, which passes them along to the calling Windows application.
AcuODBC can operate in one of three scenarios:
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550
Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
|© 1988-2003 Acucorp, Inc.|
All rights reserved.