Top

5.2.6.Oracle

OpenLink Lite Drivers for Unix can be configured in 3 ways:

Web Based Wizard
Web Based Forms
Manually

Once you have configured the generic parts of the data source using one of the above listed methods, you will need to define the driver environment. Below are the common options with their descriptions for the environment section:

      [Environment Oracle 8.0.x]
      ORACLE_HOME        = /dbs/oracle80
      ORACLE_SID         = ORCL
      ;ORACLE_SERVER          = T
      ;TWO_TASK               = P:
      ;ODBC_CATALOGS          = Y     ; Uncomment after loading odbccat8.sql
      ;MULTIPLEX_LDA          = 5     ; Allow 5 OpenLink clients on a single lda
      ;OPL_USR_TBLS_FIRST     = Y     ; Sort SQLTables starting with user tables
      SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
      CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat8.sql
      ;OCI_PREFETCH_ROWS      = 100   ; Number of rows to prefetch
      ;OCI_PREFETCH_MEMORY    = 65535 ; Amount of memory to use for prefetching
    
      [Environment Oracle 8.1.x]
      ORACLE_HOME        = /dbs/oracle81
      ORACLE_SID         = ORCL
      ;ORACLE_SERVER          = T
      ;TWO_TASK               = P:
      ;ODBC_CATALOGS          = Y     ; Uncomment after loading odbccat8.sql
      ;MULTIPLEX_LDA          = 5     ; Allow 5 OpenLink clients on a single lda
      ;OPL_USR_TBLS_FIRST     = Y     ; Sort SQLTables starting with user tables
      SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
      CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat8.sql
      ;OCI_PREFETCH_ROWS      = 100   ; Number of rows to prefetch
      ;OCI_PREFETCH_MEMORY    = 65535 ; Amount of memory to use for prefetching
    
      [Environment Oracle 8.1.x]
      ORACLE_HOME        = /dbs/oracle81
      ORACLE_SID         = ORCL
      ;ORACLE_SERVER          = T
      ;TWO_TASK               = P:
      ;ODBC_CATALOGS          = Y     ; Uncomment after loading odbccat8.sql
      ;MULTIPLEX_LDA          = 5     ; Allow 5 OpenLink clients on a single lda
      ;OPL_USR_TBLS_FIRST     = Y     ; Sort SQLTables starting with user tables
      SHOW_REMARKS       = N  ; Retrieve SQLColumns REMARKS field
      CURSOR_SENSITIVITY = LOW        ; Set to HIGH after loading odbccat8.sql
      ;OCI_PREFETCH_ROWS      = 100   ; Number of rows to prefetch
      ;OCI_PREFETCH_MEMORY    = 65535 ; Amount of memory to use for prefetching
Prev Up Next
5.2.5.Ingres Home 5.2.7.PostgreSQL