10.2. Install the ODBC Driver on Red Hat Enterprise Linux
10.2.1. Install the ODBC Driver on Red Hat Enterprise Linux Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
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 Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
Configure the Environment
Run the/opt/redhat/jboss-dv/v6/psqlodbc/etc/setenv.shscript:[localhost etc]$ ./setenv.shThis script adds the required directories to theLD_LIBRARY_PATHandPATHenvironment variables. This script has to be run every time you want to use the driver.
10.2.3. Configure the DSN for Linux Installation Copy linkLink copied to clipboard!
Copy linkLink copied to clipboard!
- Edit the
/opt/redhat/jboss-dv/v6/psqlodbc/etc/odbc.inifile 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 port35432by default.