Configure unixODBC for Oracle on AIX 32

1. Go to the $DRIVER directory.
2. Run

./odbc_update_ini.sh $UNIXODBC $DRIVER Oracle11gDriver ORAONAIX32

1. As a result, odbcinst.ini gets updated with:
   [Oracle11gDriver]
   Description = Oracle ODBC driver for Oracle 11g
   Driver = $DRIVER/libsqora.so.11.1
   Setup =
   FileUsage =
   CPTimeout =
   CPReuse =
   
2. .odbc.ini gets updated with:

[ORAONAIX32]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle11gDriver
DSN = ORAONAIX32
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MaxLargeData = 0
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName =
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID =
StatementCache=F
CacheBufferSize=20
UseOCIDescribeAny=F

3. Replace the following line in odbcinst.ini:

Driver= $DRIVER/libsqora.so.11.1
with:
Driver= $DRIVER/libsqora.so


4. Create a new Network Configuration file named $HOMEDIR/.tnsnames.ora with the following:
   

   MY_ORAQ =
     (DESCRIPTION =
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = oraclehost)(PORT = 1521))
       )
       (CONNECT_DATA =
         (SERVICE_NAME = my_oraq)
       )
     )
   

5. In the .odbc.ini file, change ServerName to be the same as SERVICE_NAME in the .tnsnames.ora file, and set UserID to SCOTT and set Password=tiger.
6. Set variables:

export LIBPATH=$UNIXODBC/lib/:$DRIVER/:
export ORACLE_HOME=$DRIVER/

7. Test the DSN connection:
   bash-3.2$ ./isql -v ORAONAIX32