Create an Oracle Data Source Name

Use the iqdsn utility to create an entry in the .odbc.ini file.

1. Display Oracle connection keywords:
   % iqdsn -cl -or

   Driver
   UserID             UID
   Password           PWD
   SID                SID
   Encrypted Password ENP
   ProcResults        PROC
   ArraySize          SIZE
   EnableMSDTC        EDTC
   ProcOwner          POWNER

2. Create an .odbc.ini file entry:
   % iqdsn -or -y -w "MyOra2" -c "UID=system;PWD=manager;SID=QAORA"

   [MyOra2]
   Driver=/Sybase/IQ-16_0/lib64/libdboraodbc12_r.so
   UserID=system
   Password=manager
   SID=QAORA