GENESIS_HOME

Connect file

The GENESIS_HOME environment variable specifies the xfODBC connect file directory.

Value

The directory that contains the connect file(s) specifying the location of the system catalog.

Discussion

GENESIS_HOME is used by the xfODBC driver, DBA, and dbcreate. It is used when you generate system catalogs, when you modify system catalogs, and when you connect to the database.

The GENESIS_HOME environment variable is required and is automatically set when you install xfODBC. You can change this setting if necessary. (Any custom settings will be saved and will not be overwritten by subsequent installations or upgrades.) On Windows, we recommend that you change the GENESIS_HOME setting and move files for the sample database and repository to a writable location outside Program Files so that files can be created and updated.

On Windows, GENESIS_HOME is set at the system level by the Connectivity Series feature of the 32-bit and 64-bit Synergy/DE installations, the 32-bit and 64-bit Synergy/DE Client installations, and the 32-bit and 64-bit xfODBC Client installations. If both 32-bit and 64-bit versions of Connectivity Series (or Synergy/DE Client or xfODBC Client) are installed on the same 64-bit machine, the first version installed determines the GENESIS_HOME setting, unless a user has set GENESIS_HOME at the system level, in which case the setting is not changed during an install, upgrade, or uninstall.

On Unix, GENESIS_HOME is set by setsde; on OpenVMS, it’s set by SYS$MANAGER:CONNECT_STARTUP.COM. (Note that we don’t recommend editing the setsde script.)

Setting location

For stand-alone configurations on Windows and Unix, GENESIS_HOME must be set in the environment. On Unix, you can change this setting either manually or by sourcing the setsde script file (located in the synergyde directory).
For stand-alone configurations on OpenVMS, GENESIS_HOME must be set in CONNECT_STARTUP.COM.
In client/server configurations, GENESIS_HOME must be set in the environment on the server, and it must be set before starting the SQL OpenNet server. SQL OpenNet only uses settings made before it is started, and it does not use settings in synergy.ini.

Used by

xfODBC