Original opensource Oracle ODBC driver page is here:

http://fndapl.fnal.gov/~dbox/oracle/odbc/

How to build Oracle ODBC driver with unixODBC on FreeBSD
--------------------------------------------------------

1) install ports/databases/unixODBC

2) install oracle817-client for FreeBSD (for example, unpack it to
/usr/local/oracle817-client)

3) set ORACLE_HOME env variable to point to oracle817-client directory
(for example, "setenv ORACLE_HOME /usr/local/oracle817-client")

4) apply patches

5) run "./configure", "make", "make install"

Running ODBC driver tests
-------------------------

ODBC DSN name in odbc.ini and service name in tnsnames.ora must be identical.
Set the following env vars:

setenv TWO_TASK=<DSN>
setenv ORACLE_USER=<USERNAME>
setenv ORACLE_PSWD=<PASSWORD>

For example,

setenv TWO_TASK=FOOBAR
setenv ORACLE_USER=scott
setenv ORACLE_PSWD=tiger

and run "make check-TESTS" in directory test/

Currently all the tests except "SQLPutTest" are verified to pass.