Active2 years, 7 months ago
I need to connect to remote DB2 from local SQL Server 2008 R2. I don't want to use linked servers. So I am searching for download and trying to install IBM DB2 driver, as Microsoft ODBC driver for DB2 comes with Host Integration Server is expensive.
putvandeBoth of them are DB2 JDBC driver jar files and are Type 4 drivers. Db2jcc.jar includes functions in the JDBC 3.0 and earlier specifications. If you plan to use those functions, include the db2jcc.jar in the application CLASSPATH.
13.3k33 gold badges2525 silver badges4747 bronze badges
ChowChow
3 Answers
You can download DB2 clients for your DB2 version from here: http://www-01.ibm.com/support/docview.wss?uid=swg27007053
Client software is free.
mustacciomustaccio15.2k99 gold badges4141 silver badges4444 bronze badges
The below link has a step by step guide that worked well for me
CidCid1,18811 gold badge1414 silver badges3535 bronze badges
Both answers are correct, but only have the links to were the answers are.
- download the correct driver (called fix pack most of the time) you need from IBM
- extract the contents of the zip file to
c:program filesIBM
, I unzipped it inc:program filesIBMclidriver
- open a command prompt as administrator and change to the directory you just created and then go in the bin folder
- execute the following commands to install and register the odbc drivers
- check your odbc manager if the drivers are installed, this is depending on the version you selected (32 bit or 64 bit)
for the 32 bit version open your odbc data sources 32 bit otherwise open the odbc data sources 64 bit.
To open odbc data sources in windows versions 7 upwards
- press the windows key
- type
odbc
- click on the version you need (32 bit or 64 bit)
Ibm Db2 Jdbc Driver Ssl
davejal4,61299 gold badges2626 silver badges6060 bronze badges