SQL OpenNet log file

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS

The VORTEX_HOST_LOGFILE environment variable turns on logging and specifies the path and name of the log file used to log statements passed to SQL OpenNet from the xfODBC driver and SQL Connection.


The path and name of the Vortex host log file you want to produce. You do not need to specify a filename extension.


VORTEX_HOST_LOGFILE specifies the file that logs calls and errors generated through SQL OpenNet server. You can use it to determine the driver API calls made between the driver client and the OpenNet server.

Vortex host logging applies only to a client/server configuration. You can use Vortex host logs only with vtxnet2. Vtxnetd (on Windows) does not support the VORTEX_HOST_LOGFILE environment variable.

Use the VORTEX_HOST_LOGOPTS environment variable to set options for the log file. If you set VORTEX_HOST_LOGFILE without setting VORTEX_HOST_LOGOPTS, the log file includes a list of all operations along with a total count for each operation.

Once you have successfully logged the error, turn logging off by unsetting the VORTEX_HOST_LOGFILE and VORTEX_HOST_LOGOPTS environment variables (and reboot if necessary). Logging slows performance, and the log files can quickly fill your disk.

Setting location

The server, as follows:

Used by

xfODBC, SQL Connection

See also