Installing Db2 On Windows Server 2008

1. Installing Windows Server 2012 R2
2. Windows Server 2008 Download
3. Install Db2 On Windows 10

1. Hostname: Should point to the server where your DB2-server is installed. Port: The portnumber where the DB2-server on the Hostname is responding. Protocol: The protocol used to connect to the DB2-server. There’s different options as you can se in the picture below. The final settings should be the ones listed below.
2. Hi, We recently installed DB2 Connect 10.5 on Windows Server 2012 R2 hosting SQL Server 2008 R2. We are able to connect successfully to DB2 Data Sources via the command interface but when we actually create a linked server and test the connection from within SQL Server it throws the following errors.

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.

putvande

While installing DB2 for Windows on or prior to 10.5 Fix Pack 3, 10.1 Fix Pack 3 and 9.7 Fix Pack 9 on Windows 8.1 and Windows 2012 R2, you might receive GUI related errors, errors related to shortcuts created during the installation, and errors pertaining to the db2prereqcheck tool.

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.

mustacciomustaccio

The below link has a step by step guide that worked well for me

CidCid

Both answers are correct, but only have the links to were the answers are.

1. download the correct driver (called fix pack most of the time) you need from IBM
2. extract the contents of the zip file to c:program filesIBM , I unzipped it in c:program filesIBMclidriver
3. open a command prompt as administrator and change to the directory you just created and then go in the bin folder

4. execute the following commands to install and register the odbc drivers

5. 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

1. press the windows key
2. type odbc
3. click on the version you need (32 bit or 64 bit)

davejal

Installing Windows Server 2012 R2

davejal

Windows Server 2008 Download

Install Db2 On Windows 10

Not the answer you're looking for? Browse other questions tagged sql-serverdb2odbcdriver or ask your own question.