Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
10.2. Install the ODBC Driver on Red Hat Enterprise Linux
10.2.1. Install the ODBC Driver on Red Hat Enterprise Linux
Prerequisites
- Administrative permissions are required.
Procedure 10.1. Install the ODBC Driver on Red Hat Enterprise Linux
Download the driver
Download the correct ODBC driver package (jboss-dv-psqlodbc-[version]-X.rpm
) from https://access.redhat.com/jbossnetwork/.Install the package
Runsudo yum localinstall
.jboss-dv-psqlodbc-[version]-X.rpm
Note
Installation packages for different operating systems can be downloaded from https://access.redhat.com/jbossnetwork/.
10.2.2. Configure the ODBC Environment
Configure the Environment
Run the/opt/redhat/jboss-dv/v6/psqlodbc/etc/setenv.sh
script:[localhost etc]$ ./setenv.sh
This script adds the required directories to theLD_LIBRARY_PATH
andPATH
environment variables. This script has to be run every time you want to use the driver.
10.2.3. Configure the DSN for Linux 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 port35432
by default.