Other environment variables used by xfODBC

These environment variables, with the exception of VORTEX_HOST_NOSEM, are required and in most cases are set automatically by the installation (Windows), the setsde script (UNIX), or the SYS$MANAGER:CONNECT_STARTUP.COM command file (OpenVMS). See Configuring Connectivity Series for more information on setsde and CONNECT_STARTUP.COM. See the individual environment variable topics for additional details.

Environment variable

Purpose

See also

CONNECTDIR

Set to the location of the synergyde\connect directory.

N/A

SODBC_DBA

Set to the directory that contains the DBA program (which is xfdba.dbr on Windows and UNIX and xfdba.exe on OpenVMS).

For client/server configurations, SODBC_DBA must be set on the server.

Opening the system catalog in DBA

VORTEX_HOME

Set to the directory (connect\synodbc) that contains the lib subdirectory, which contains the net.ini file. This file is used for encryption and other SQL OpenNet settings.

Setting SQL OpenNet client options in net.ini

VORTEX_HOST_HIDEGPF
(Windows)

Prevents the SQL OpenNet server from hanging if a thread fails.

N/A

VORTEX_HOST_NOSEM (Windows)

When set to 1, causes SQL OpenNet to crash when there’s an access violation, enabling you to attach the Windows debugger.

N/A

VTXIPC_SO
(OpenVMS)

Set to the full path and filename of the vtxipc_so.exe shared image. This setting should not be changed.

N/A

XFODBCUSR_SO
(OpenVMS)

Set to the full path and filename of the xfodbcusr_so.exe shared image, which contains routines for user-defined data.

Introduction to writing C-language routines

Using xfodbcusr.c as a template to create user-defined data routines