8.7. Install the ODBC Driver on Solaris

Prerequisites

Download the correct ODBC driver package (jboss-dv-psqlodbc-[VERSION]-X.zip) from https://access.redhat.com/jbossnetwork/.
Unzip the installation package
Unzip the installation package to /opt directory.
Set the 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
Set the ODBCINI environmental variable to match the 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, so that you do not need to run them every time. Likewise, if you are using Bash, save them in your ~/.bash_profile file instead.