Before using AcuODBC Server, you must perform the following steps:
1. If the DSN will be on a UNIX server, you must assign a value to the DSN_DIRECTORY configuration variable.
2. To ensure proper system security, identify users to the system by adding their names and passwords (if appropriate) to the AcuAccess file.
3. Start AcuODBC Server as a service or daemon.
4. Configure the DSN on both the client and the server.
a. If SQL processing will occur on a Windows server, use the AcuODBC Server Configuration utility to create the remote DSN.
b. If SQL processing will occur on a UNIX server, you can use either the srvconfig.sh or srvconfig.tcl utilities to configure the remote DSN. srvconfig.sh is a command-line interface. srvconfig.tcl is a graphical interface.
The AcuODBC Server is called acuodbcs. This is a single-instance server: each time AcuODBC Server gets a request, it spawns a new copy to deal with the request and the original goes back to listening for additional requests.
This chapter describes the AcuODBC Server environment. In addition, the chapter provides information on the "AcuAccess" file, the basis of AcuODBC Server security. Finally, the chapter also describes the user interface and commands for running AcuODBC Server as a Windows service or a UNIX daemon.