DB2 ODBC CLI driver Installation

There is no installation program for the stand alone IBM Data Server Driver for ODBC and CLI. You must install the driver manually:

1. Copy the compressed file that contains the driver onto the target machine from the internet or a DB2 Version 9 installation CD.
2. Uncompress that file into your chosen install directory on the target machine.
3. Optional: remove the compressed file.

If you are installing the IBM Data Server Driver for ODBC and CLI under the following conditions:

• the operating systems on the target machine is AIX®; and
• the DB2 Version 9 CD is mounted on the target machine.

the steps you would follow are:

1. Create the directory $HOME/db2_cli_odbc_driver, where you will install the driver.
2. Locate the compressed file ibm_data_server_driver_for_odbc_cli.tar.Z on the install CD.
3. Copy the tar file ibm_data_server_driver_for_odbc_cli.tar.Z to the install directory, $HOME/db2cli_odbc_driver.
4. Uncompress ibm_data_server_driver_for_odbc_cli.tar.Z:

• cd $HOME/db2_cli_odbc_driver
• tar -xvf ibm_data_server_driver_for_odbc_cli.tar

1. Delete ibm_data_server_driver_for_odbc_cli.tar.Z.
2. Ensure the following if you installed the driver on a NFS file system:
3. On UNIX® or Linux® platforms the db2dump and the db2 directory need to be writable. Alternatively, the path you have referenced in the diagpath parameter must be writable.
4. If host or i5/OS® data servers are being accessed directly ensure the license directory is writable.

If you are installing the IBM Data Server Driver for ODBC and CLI on Windows Platform, then you could copy the compressed folder under C:\Program Files\IBM and uncompress it. If you want to register the newly installed driver into the OBCD Administrator tool, then run the exe db2oreg1.exe located under the bin directory of the uncompressed driver(e.g: <uncompressed driver folder>/bin/db2oreg1.exe) from the command prompt as:

cd <uncompressed driver folder>/bin
db2oreg1 -i

After the above command is run to complete, you could see the driver registered in the ODBC Data source Administrator's Driver panel.

If you are installing 32-bit ODBC Driver on 64-bit Windows Operating System then you might hit the error "Data source name not found and no default driver specified".
Please follow the guidelines from the below link to resolve the issue:
Pointing to 32 bit ODBC driver on 64 bit Microsoft system

You could also find the resolution in the Microsoft Technote:
http://support.microsoft.com/kb/942976

http://www-01.ibm.com/support/docview.wss?uid=swg21418043#%5B%3Ch2%3E%5DInstallation%5B%3C%2Fh2%3E%5D