To install the ODBC driver, you can manually create ODBC .ini files or add to the existing .ini file for the ODBC driver manager you are using. Use the following procedure:
Download and unzip the ODBC driver manager .tar.gz file from the Pivotal GemFire XD product page. For example:
tar -zxvf Pivotal_GemFireXD_XX_bNNNNN_ODBC.tar.gz -C path_to_install_location
where path_to_install_location is an already existing directory.
Download and install the ODBC driver manager you wish to use. See ODBC Driver Supported Configurations for a list of supported platform architectures and driver managers.
Create or modify your odbcinst.ini file to point to the path of the ODBC driver shared library. Use the following values depending on your driver configuration:
unixODBC driver manager:
32-bit: path_to_install_location/odbc/32/libgemfirexdodbc.so
64-bit: path_to_install_location/odbc/64/libgemfirexdodbc.so
iODBC driver manager:
32-bit: path_to_install_location/odbc/32/libgemfirexdiodbc.so
64-bit: path_to_install_location/odbc/64/libgemfirexdiodbc.so
The following is a sample odbcinst.ini file for the unixODBC driver manager:
[ODBC]
Trace = yes
TraceFile = dmtrace.log
[ODBC Drivers]
SQLFODBC = Installed
[SQLFODBC]
Driver = /usr/lib/gphd/gfxd/odbc/64/libgemfirexdodbc.so
Description = Driver for connecting to GemFire XD database server
Create or modify your odbc.ini file to identify the GemFire XD data source name (DSN).
The following is a sample odbc.ini file for the unixODBC driver manager:
[ODBC Data Sources]
data_source_name = testdsn
[testdsn]
Driver = /usr/lib/gphd/gfxd/odbc/64/libgemfirexdodbc.so
DESCRIPTION = GemFire XD ODBC driver
SERVER = localhost
PORT = 1527
UID =
PASSWORD =
LogFile = gfxdodbc.log
Finally set the ODBCINI and ODBCSYSINI environment variables to the file location where odbc.ini and odbcinst.ini files for your driver manager are located. If you are using the iODBC driver manager, also set the ODBCINSTINI environment variable to the location of your odbcinst.ini file. For example:
export ODBCINI=/home/user/odbc.ini
export ODBCINSTINI=/home/user/odbcinst.ini
export ODBCSYSINI=/home/user/odbcinst.ini
If installing on Mac OSX, set the DYLD_LIBRARY_PATH environment variable to the location where you installed the driver files.
export DYLD_LIBRARY_PATH=path_to_install_location
Ethan Stark
Software Developer
Cloud Hosted Virtual Desktop