Why do I get error "Could not load Oracle libraries" or "ORACLE_HOME environment variable not set" when using the Oracle ODBC driver?

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.