AcuODBC User's Guide
2.5 Comparing AcuODBC Server and AcuODBC with AcuServer
To gain access to remote Vision files over a network, you must have either AcuServer or AcuODBC Server installed on the server. Which technology is appropriate for your environment depends on whether you will be retrieving full data files or issuing requests for specific sets of records.
To determine which remote access solution is best for your environment, consider the following:
- Use AcuODBC with AcuServer if your site uses Microsoft Word, Microsoft Access, Microsoft Excel, or other applications that dynamically generate SQL to browse records in a file or table. These applications import entire files, without regard for how the SQL commands are passed to the server.
AcuServer allows you to locate files and return them to the local machine for processing, and gives you the greatest amount of remote access flexibility.
- Use AcuODBC Server if your site uses either a report writer application such as Crystal Reports Professional or custom a VB application that uses known SQL with specific retrieval criteria.
With AcuODBC Server, the SQL query is processed on the server, and only the result is returned to the client, reducing network traffic. As a result, in environments where non-dynamically generated, complex SQL is used by report writing software, AcuODBC Server can provide improved performance.
Note that if you have multiple applications that access your remote Vision files (for example, if you also have an ACUCOBOL-GT runtime accessing Vision), AcuServer may be your best choice.
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.