Configure unixODBC for Oracle on Solaris

1. Go to the Instant Client installation directory: $DRIVER
2. Run

./odbc_update_ini.sh $UNIXODBC $DRIVER Oracle11gDriver ORAONSOL

1. The $UNIXODBC/etc/odbcinst.ini file is updated with:

[Oracle11gDriver]
Description = Oracle ODBC driver for Oracle 11g
Driver = $DRIVER/libsqora.so.11.1
Setup =
FileUsage =
CPTimeout =
CPReuse =


2. The $HOMEDIR/.odbc.ini file is updated with:

[ORAONSOL]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle11gDriver
DSN = ORAONSOL
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. Create a new Network Configuration file named $HOMEDIR/.tnsnames.ora with the following:

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

Important
MY_ORAQ is a sample name only.
4. In the .odbc.ini file, change ServerName to be the same as SERVICE_NAME in .tnsnames.ora, and set the UserID and Password
5. Set Environment Variables:

export LD_LIBRARY_PATH=$UNIXODBC/lib/:$DRIVER/
export ORACLE_SID=my_oraq

6. Go to $UNIXODBC/bin and test DSN with the command:

./isql -v ORAONSOL