Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

10.4. Install the ODBC Driver on Solaris

10.4.1. Install the ODBC Driver on Solaris

Prerequisites

  • Administrative permissions are required.

Procedure 10.4. Install the ODBC Driver on Solaris

  1. Download the driver

    Download the correct ODBC driver package (jboss-dv-psqlodbc-6.0.0-X.zip) from https://access.redhat.com/jbossnetwork/.

  2. Unzip the installation package

    Unzip the installation package to /opt directory.

  3. Set the PATH Property

    Set PATH property so that the ODBC binaries are used from the directory where you have unzipped the driver.
    $ export PATH = $PATH:/opt/redhat/jboss-dv/v6/psqlodbc/bin

  4. Set environmental variable

    Set ODBCINI environmental variable to existing odbc.ini.
    $ export ODBCINI=/opt/redhat/jboss-dv/v6/psqlodbc/etc/odbc.ini

    Note

    If you are using the Bourne Shell as your Solaris terminal, you can add the two export commands above to your ~/.profile file, you will not need to run them every time. Likewise, if you are using Bash, save them in your ~/.bash_profile file instead.

10.4.2. Configure the DSN for Solaris Installation

  • Edit the /opt/redhat/jboss-dv/v6/psqlodbc/etc/odbc.ini file and update it with the correct username, password, and database. The database name is the VDB name.
    ODBC is enabled in JBoss Data Virtualization on port 35432 by default.