AcuODBC User's Guide
Version 6.0

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:

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 -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.

Acucorp, Inc.
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.