The OCI version of the Oracle ODBC driver uses Oracle's client libraries. If you're using the OCI driver with the standard database client, you need to set the ORACLE_HOME
environment variable to the Oracle or Oracle client directory. Refer to When do I get error "[EasySoft]ORACLE_HOME not defined Error 69?"
The Oracle ODBC driver distribution includes a program called checksys
, which tests everything is set up correctly. checksys
is located in /usr/local/easysoft/oracle
. You run checksys
like this:
./checksys -d oracle_data_source
where oracle_data_source
is the name of your Oracle ODBC driver data source. checksys
can tell you if ORACLE_HOME
is set correctly and diagnose many other setup issues.