10.4. Install the ODBC Driver on Solaris

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.

• 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.