如何在Windows 7 - 64位中安装IBM db2 ODBC驱动程序？

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.

我需要从本地SQL Server 2008 R2连接到远程DB2。我不想使用链接服务器。所以我正在寻找下载并尝试安装IBM DB2驱动程序,因为用于DB2的Microsoft ODBC驱动程序与Host Integration Server一起使用是昂贵的。

3 个解决方案

#1

You can download DB2 clients for your DB2 version from here: http://www-01.ibm.com/support/docview.wss?uid=swg27007053

您可以从此处下载DB2版本的DB2客户机:http://www-01.ibm.com/support/docview.wss?uid = swg27007053

Client software is free.

客户端软件是免费的。

#2

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

以下链接有一个分步指南,对我来说很有用

http://www.ryslander.com/how-to-install-and-configure-db2-odbc-driver/

#3

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

从IBM下载所需的正确驱动程序(大多数时候称为修订包)

extract the contents of the zip file to c:\program files\IBM , I unzipped it in c:\program files\IBM\clidriver

将zip文件的内容解压缩到c:\ program files \ IBM,我在c:\ program files \ IBM \ clidriver中解压缩它

open a command prompt as administrator and change to the directory you just created and then go in the bin folder

以管理员身份打开命令提示符并切换到刚刚创建的目录,然后进入bin文件夹

execute the following commands to install and register the odbc drivers

执行以下命令安装和注册odbc驱动程序
```
db2oreg1 –i

db2oreg1 –setup
```
check your odbc manager if the drivers are installed, this is depending on the version you selected (32 bit or 64 bit)

检查您的odbc管理器是否安装了驱动程序,这取决于您选择的版本(32位或64位)

for the 32 bit version open your odbc data sources 32 bit otherwise open the odbc data sources 64 bit.

对于32位版本打开你的odbc数据源32位否则打开odbc数据源64位。

To open odbc data sources in windows versions 7 upwards

在Windows版本7中向上打开odbc数据源

press the windows key

按下Windows键

type odbc
click on the version you need (32 bit or 64 bit)

单击您需要的版本(32位或64位)

#1