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_ias_odbc_driver_for_oracle]Driver=full-path/libdboraodbc10_r.soUserID=user-idPassword=passwordSID=TNS-service-nameProcResults=[yes|no]ArraySize=bytes
  2. Click Add.
  3. Choose iAnywhere Solutions 11 - Oracle, then click Finish.
  4. Specify the configuration options.
  5. Click Test Connection, then click OK.