AcuODBC User's Guide
8.1 AcuODBC Server
The AcuODBC® Server provides you with a true two-tier environment - one in which SQL processing is performed remotely on an application server, with the results returned to the client machine. This has several advantages:
- Network traffic is reduced, since only queries are sent to the server and results returned to the client.
- Application servers are generally faster, more powerful machines, so the processing is accomplished more quickly.
- The remote server can run in the background as a service (or daemon) consuming few resources until called upon.
- This scenario facilitates centralized management of data, cutting down on duplication and ensuring that information returned to the application is always up-to-date.
Note that the data source name (DSN) is located on the remote server.
The AcuODBC Server is called acuodbcs. This is a single-instance server: each time acuodbcs gets a request, it spawns a new copy to deal with the request and the original goes back to listening for additional requests.
If you are running AcuODBC Server under Windows, you can manage access files, data sources, and services through the AcuODBC Server Control Panel (ODCP). This control panel provides all of the functionality of using the acuodbcs command from the command line, and also includes all Data Source Configuration Utility functions.
In UNIX environments and from the Windows command prompt, the acuodbcs command allows you to manage access files, data sources, and services. Note that entering the acuodbcs command with no options at the Windows command line opens the ODCP. In UNIX environments, entering the acuodbcs command with no options returns a usage list for the command:acuodbcs acuodbcs -access acuodbcs -kill [server] [-n portnum] acuodbcs -start [-c config] [-e error] [-l] [-t #] [-f] [-n portnum] acuodbcs -version
This chapter describes the AcuODBC Server environment, including detailed explanations of how to use the ODCP and the acuodbcs command to run AcuODBC Server as a Windows service or a UNIX daemon. This chapter also provides information on the "AcuAccess" file, the basis of AcuODBC Server security.
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.