ODBC Oracle Driver
 
 
 

Download version 3.0 of the Easysoft ODBC Oracle driver. This driver works with both the 10gR1 database client or instant client. The install package includes a version of the Unix ODBC Driver Manager. For more information about the driver manager software, browse http://www.unixodbc.org.

  1. Browse http://www.easysoft.com.
  2. Click Products.
  3. Scroll. Click Easysoft ODBC-Oracle driver.
  4. Login.
  5. Select Linux - x86 - (32-bit) from the platform list box.
  6. Click Download. This action initiates the download of odbc-oracle-3.0.0-linux-x86-glibc.tar.

Untar the download file. Untarring odbc-oracle-3.0.0-linux-x86-glibc.tar causes the contents of the tar file to be written to a directory called odbc-oracle-3.0.0-linux-x86-glibc. Read the INSTALL.txt file. This document recommends that you do the installation as root so that you can install to /usr/local. It also recommends that you install the version of the unixODBC driver manager that comes bundled with the Easysoft ODBC-Oracle driver installation package. The document explains what options were used to build this version of the driver manager and thus how it differs in behavior from what you will get if you install a version from http://www.unixODBC.org. The document explains how to install the licensed version of the driver.

The installation described here followed the recommendations to install as root to /usr/local and to use the bundled unixODBC driver manager. It also installed a licensed version using the license script called by the installer script. This is optional. You have the option of leaving the step of acquiring a license to a later time.

NoteThe unlicensed version does not work with Oracle 10g databases.

In a terminal window do the following:

Before you begin, verify that there is no previous easysoft installation. Check /etc for the odbc.ini and odbcinst.ini files. Check the /etc/ld.so.conf file for easysoft paths. Check for an easysoft directory in /usr/local. The latter is the default install location.

  1. su - root
  2. export ORACLE_HOME=<pathToOracleClient>
    NoteThe target RHEL3.0 machine has a 10gR1 full client installed in /app/oracle/OraHome_1. So for this exercise <pathToOracleClient> is /app/oracle/OraHome_1. DO NOT use the Oracle instant client.
  3. cd <path>/odbc-oracle-3.0.0-linux-x86-glibc
  4. ./install
  5. Read the license and type yes to accept it.
  6. Press enter to accept the default location (/urs/local).
  7. Press enter to accept the default no answer to the question about there being a unixODBC driver manager already installed.
  8. Press enter to accept the yes answer to the question about requesting an Easysoft ODBC-Oracle Driver License now. This causes the license script to run. It runs inline with the installer script.
  9. Type 2 to initiate the acquisition of a license for the driver.
  10. Supply values for your name, company, email address, phone number, fax number, and license authorization number.
  11. Select the option to obtain the license automatically from the Easysoft license daemon.
  12. Select the option to exit from licensing script and return to the installer script. The installer script tells you that it will create a data source called ‘ORACLE.’
  13. Enter the Oracle Database Name. Since we connect to the database by way of a client, we specify the Net Service Name. This is one of the names found in the $ORACLE_HOME/network/admin/tnsnames.ora file. This name indexes a structure containing the hostname, port, and database service name of the instance to connect to.
  14. Enter an Oracle user name. This name must be a valid user in the Oracle instance.
  15. Enter the Oracle password for <user> where <user> is value you just entered in the previous step.
  16. Press enter to answer yes to the question about installing the driver data source. This completes the installation.
  17. cd /usr/local/easysoft/unixODBC/bin
  18. ./isql -v ORACLE You should get a message saying ‘Connected’ and the SQL prompt.
    Note‘ORACLE’ is the name of the data source created by the installer. The information about the data source is in the /etc/odbc.ini file.
NoteThe build script uses the FDOODBC environment variable to locate the ODBC libraries. The script expects to find a lib directory in the path value contained in FDOODBC. The FDOODBC variable is set by the setenvironment.sh script; for more information, read the section entitled “Environment Variables.”

As a result of the installation the odbc.ini and odbcinst.ini files are written to /etc. The odbcinst.ini identifies the shared object files for the driver, and the odbc.ini contains mapping of the Data Source Name (DSN) to the Oracle database. You will need this DSN to run the unit tests.