Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

Specifying the configuration file location

We recommend that the FairCom DB SQL callback configuration file be located in the operating directory. By default, the FairCom DB SQL callback dynamic library will try to locate the configuration file in the current directory.

There are certain circumstances that can cause the current directory to change, or to be undefined, after the server begins execution. If the server is started as a service under Windows, the current directory may be undefined, or if the server is started as a daemon under Unix systems, the current directory may change.

For these circumstances, the location of the configuration file may be specified using the FairCom DB SQL configuration file. The following entry can be added to the server’s configuration file to specify the location of the FairCom DB SQL callback configuration file:

APP_NAME_LIST full-path-of-configuration-file

Example

SERVER_NAME FAIRCOMS

SQL_DATABASE ctreeSQL

COMPATIBILITY LOG_WRITETHRU

CONSOLE NO_SHUTDOWN_PROMPT

DAT_MEMORY 5000000

IDX_MEMORY 9000000

APP_NAME_LIST C:\FairCom\V8.27\ctreeServers\ctreeSQLServer\ctsqlcbk.ini

When using the APP_NAME_LIST server configuration keyword to specify the location of the configuration file, make sure the APP_NAME_LIST is the first one in the configuration file, that is, no other APP_NAME_LIST entries may appear before the entry that specify the location of the configuration.

TOCIndex