There are two entries for each database entry.
#Missing odbc manager install#
(c) Install the DS driver, in this example we install it in /opt/ibm/db2/dsdriver.Įdit db2dsdriver.cfg and place the following inside it. (b) Select the platform and download "IBM Data Server Driver Package". (a) Select "Data Server Driver Package" for the DB2 release. Reference: Please refer to link "Setting Up ODBC Environment" bashrc, source the profile again or exit and login again for the new environment variables to take effect. The ODBC libraries are usually located in the path below:Īfter editing. # chmod 755 /opt/ibm/db2/dsdriver/db2profile # Source DB2 profile from IBM Data Server DriverĮxport LD_LIBRARY_PATH=/usr/lib64/libodbc.soĮnsure /opt/ibm/db2/dsdriver/db2profile has permission to execute db2profile. (b) Later, we will create and configure the System and User DSN files (odbc.ini and. USER DATA SOURCES.: /home/db2inst1/.odbc.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.iniįILE DATA SOURCES.: /usr/local/etc/ODBCDataSources Get ODBC configuration file locations and make note of the System and User Data Sources file locations.ĭRIVERS.: /usr/local/etc/odbcinst.ini For User Data Sources, it will look for a hidden file in the current user's home directory called. (a) Install the ODBC Driver Manager as per link below:įor step #3 in the link above, run the "odbcinst -j" command to find the location of the configuration files for SYSTEM/USER DATA SOURCES. The DS Driver can be installed in the user's home directory as well such as /home/db2inst1/dsdriver.ġ) Install & Configure ODBC Driver Manager Root id will be required to configure the ODBC driver manager configuration files and the IBM Data Server (DS) Driver if it is installed in /opt/ibm/db2/dsdriver as per our example. This example assumes the application requiring ODBC connectivity will be run with the userid "db2inst1" and will connect to:
0 kommentar(er)
