How to change ODBC Driver Manager? Post: 302999098

Sponsored Content

Operating Systems Linux How to change ODBC Driver Manager? Post 302999098 by Ethan Stark on Tuesday 13th of June 2017 07:35:41 AM

06-13-2017

Registered User

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

Last edited by Ethan Stark; 06-14-2017 at 05:26 AM..

Ethan Stark

View Public Profile for Ethan Stark

Find all posts by Ethan Stark

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ODBC Driver for UNIX

I have no experiance in Unix and I am trying to help our DBAs set up a connection from a Unix Oracle box to a DB2 database on an AS400 server. Does anyone know where I might find a good generic ODBC driver for Unix that should be able to connect to AS400? Any links to sites that would help would...

2. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ...

3. Hardware

Difference between platform driver,codec driver and Machine driver

In general terms what are the differences platform driver,codec driver and Machine driver?

4. Linux

rpm packaging issue for unixodbc driver manager

Hi All, I am trying to make rpm package for unixODBC driver manager 2.3.0 using below spec file. During rpmbuild i am getting the error. Can you pls advice how we can overcome this issue %define name unixODBC %define ver 2.3.0 %define prefix /usr %define sysconfdir /etc %define libdir...

5. Red Hat

Linux ODBC driver issue

Hi Gurus, I have a odbc in Linux. when I run command ldd. I got following result: # ldd DWora26.so linux-vdso.so.1 => (0x00007fff26355000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc31e70a000) librt.so.1 => /lib64/librt.so.1 (0x00007fc31e501000) ...

6. SCO

How to change raid controller driver ? (hardware change)

Hello I'm trying to virtualize an instance of Sco Unix 5.0.5 in VirtualBox (called VM-A) , but sco I have problems set to launch with the new raid controller . The physical machine has a raid controller adaptec (alad driver) but VirtualBox uses buslogic (blc driver) What ...

LEARN ABOUT CENTOS

odbcinst

odbcinst(1)						       unixODBC manual pages						       odbcinst(1)

NAME

       odbcinst - An unixODBC tool for manipulating configuration files

SYNOPSIS

       odbcinst ACTION OBJECT OPTIONS

DESCRIPTION

       odbcinst  is  a	command line tool which has been created for allowing people who are developing the install scripts/RPMs for Drivers to be
       able to easily create/remove entries in odbc.ini and odbcinst.ini. This command line tool is a complement to the shared library of the same
       name (libodbcinst.so). This tool is a part of the odbcinst component of unixODBC.

OPTIONS

   ACTIONS
       -i     Install (add section to config file) new OBJECT.

       -u     Uninstall (remove section from config file) existing OBJECT.

       -q     Query the config files and print the options for specified OBJECT.

       -j     Prints current configuration of unixODBC, listing (among others) the paths to the configuration files.

       -c     Calls SQLCreateDataSource

       -m     Calls SQLManageDataSources

       --version
	      Prints program version and exits.

   OBJECTS
       -d     The ACTION affect drivers (and thus the odbcinst.ini configuration file).

       -s     The ACTION affect data sources (and thus the user or system odbc.ini configuration file).

   OPTIONS
       -f FILE
	      The FILE is template file, describing the configuration of installed OBJECT (only valid for the -i ACTION).

       -r     Same as the -f OPTION, only take the standard input as the template file.

       -n NAME
	      Specifies the NAME of the OBJECT.

       -v     Turn off verbose mode. This turns off all information, warning and error messages.

       -l     The specified data source is system-wide. Has any effect only with the -s OBJECT.

       -h     The specified data source is user-specific. Has any effect only with the -s OBJECT.

RETURN VALUES

       This command returns zero on success and non-zero value on failure.

FILES

       /etc/odbinst.ini
	      Configuration file containing all the database drivers specifications. See odbcinst.ini(5) for more details.

       /etc/odbc.ini
	      System-wide data sources specifications. See odbc.ini(5) for more details.

       $HOME/.odbc.ini
	      User-specific data sources specifications. See odbc.ini(5) for more details.

SEE ALSO

       odbcinst.ini(5), odbc.ini(5)

AUTHORS

       The  authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of contributors
       see the AUTHORS file.

COPYRIGHT

       unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file.

version 2.3.1							  Wed 26 Jun 2013						       odbcinst(1)