Creating an Oracle DSN on UNIX

On UNIX, you may set up the driver in an ODBC system information file (typically called .odbc.ini).

1. Use a text editor to edit the system information file. The section for this driver should appear as follows (with appropriate values entered for each field):

   [sample_dsn_using_the_sa_odbc_driver_for_oracle]
   Driver=full-path/libdboraodbc16_r.so
   UserID=user-id
   Password=password
   SID=TNS-service-name
   ProcResults=[yes|no]
   ArraySize=bytes

2. Click Add.
3. Choose iAnywhere Solutions 16 - Oracle, then click Finish.
4. Specify the configuration options.
5. Click Test Connection, then click OK.