I get the error "ORACLE_HOME environment variable not set" when using an Easysoft product. What can I do?

There are two possible solutions for an Easysoft server (Easysoft ODBC-ODBC Bridge, Easysoft JDBC-ODBC Bridge, Easysoft XML-ODBC Server) running on Linux or UNIX:

• Set and export ORACLE_HOME before starting the Easysoft server in standalone mode. The server is located in installation_dir/easysoft/server_product/server. (The default location for installation_dir is /usr/local.)

  ORACLE_HOME=oracle_libraries_dir
  export ORACLE_HOME

• Set and export ORACLE_HOME in the server script in installation_dir/easysoft/server_product/server if running the server under {x}inetd.

Here's an additional solution if you're using the XML-ODBC Server:

• Add an Environment element to the request sent from your client to the server. The Environment element data should be ORACLE_HOME=oracle_libraries_dir:

  <Request>
    <Environment>
        ORACLE_HOME=oracle_libraries_dir
    </Environment>
      .
      .
      .      
  </Request>

It's also possible to set environment variables such as ORACLE_HOME in the odbc.ini file by using the DMEnvAttr attribute.

It would be unlikely for this issue to happen on a Microsoft Windows platform, as ORACLE_HOME is set by the Oracle installer.

Note If you are using the Instant Client, you need to set LD_LIBRARY_PATH instead of ORACLE_HOME. Set LD_LIBRARY_PATH to specify the Instant Client directory. For example:

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:instant_client_dir
export LD_LIBRARY_PATH