| Products | Minisoft News | Events | Downloads | Product Manuals
 
  News

Press Release:
ODBC now supporting Eloquence, AIX, OSX, UNIX, LINUX, and Oracle Open Gateway for Heterogeneous Queries

Press Release:
Minisoft Releases PCI Compliant Versions of ODBC, JDBC, and OLE DB


Demo and Updates

Download an Evaluation today!

ODBC Updates


Documentation

ODBC for Unix Documentation


Product Review

Tracing Facilities

Setting Environment Variables

DSN and odbc.ini

config3kodbc

  Driver Installation

Installing on HP-UX

Installing on Solaris

Installing on Linux

Installing on OSX

Installing on AIX

  Oracle Users

ODBC and Oracle Instructions

ODBC and Oracle FAQ

  Server Installation

Server on an HP-UX

 
   



ODBC - Oracle pre 11 Installation Instructions

ODBC/32 driver version 2.2.5.3 and later is compatible with Oracle Heterogeneous Services, Generic Connectivity for ODBC.

Oracle's Generic connectivity is intended for data integration solutions requiring the capability to connect from Oracle to non-Oracle database systems. Generic Connectivity is part of Oracle Heterogeneous Services.

Oracle versions


Operating Systems

  • HPUX (HPPA)
  • Solaris (Sparc)
  • Windows (i386)
  • Linux (i386) (While the Minisoft driver is available, Generic Connectivity is not supported in all releases of Oracle for Linux.)

With the appropriate MPE and Image security, you can select, update, insert and delete records from your Oracle applications.

Read and write Image, KSAM and MPE files.

Using Oracle Generic Connectivity

This is a step-by-step guide for setting up and troubleshooting Generic Connectivity using ODBC, of Oracle 8i.

  1. With the OUI (Oracle Universal Installer) install Generic Connectivity using ODBC. This product is part of the server installation, because a listener is needed. A directory called ORACLE_HOME/hs is created.
      
  2. The Generic Connectivity utility needs data dictionary tables in the Oracle database. To check their existence, run a query on i.e. SYS.HS_FDS_CLASS. If it fails, run the caths.sql script located in ORACLE_HOME/RDBMS/ADMIN as user sys or internal.
      
  3. Install and test the MiniSoft ODBC/32 Driver.
      
  4. Configure tnsnames.ora. This file is in ORACLE_HOME/network/admin. Add the following lines to the file:
      
    hsodbc =
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)
    (HOST=<HOSTNAME>)
    (PORT=1521))
    (CONNECT_DATA=(SID=hsodbc))
    (HS=)
    )
      
    Note, a sample file is located in ORACLE_HOME/hs/admin.
      
  5. Configuring listener.ora this file is in ORACLE_HOME/network/admin. Add the following line to the SID_List of the listener.ora and restart the listener afterwards. ( After the restart a service handler for hsodbc should exist).
      
    (SID_DESC=
    (SID_NAME=hsodbc)
    (ORACLE_HOME=/u01/product) |<- adjust Oracle_Home directory
    (PROGRAM=hsodbc)
    )
      
    Note, a sample file is located in ORACLE_HOME/hs/admin.
      
  6. Adjust the configuration file of the gateway. It is located in ORCALE_HOME\HS\ADMIN. The name depends on the SID you use for the Heterogeneous Service. In our sample the listener SID is hsodbc and so the configuration file is inithsodbc.ora.
    HS init parameters:
      
    HS_FDS_CONNECT_INFO = mstest |<- ODBC Data Source Name
    HS_FDS_TRACE_LEVEL = 0 |<- trace levels from 0 to 4 (4 is maximum)
    HS_FDS_TRACE_FILE_NAME = |<- Name of the trace file.
    HS_FDS_SHAREABLE_NAME = |<- /opt/minisoft/lib3kodbc.so
    set ODBCINI= |<- /usr/local/etc/odbc.ini
      
  7. Testing the connectivity:
      
    - create a database link:
      
    create database link hsodbc using 'hsodbc';
      
    - select * from emp@hsodbc;