如何安装 DB2 ODBC 或 OLEDB 驱动程序 [英] How to install DB2 ODBC or OLEDB Driver

问题描述

我已经在 Windows 7 Pro 上安装了 IBM DB2 Database Express.

I have already installed IBM DB2 Database Express on Windows 7 Pro.

现在，我想创建我的 C# 代码，以便在 DB2 表中选择/插入/更新记录.

Now, I would like to create my C# code in order to select/insert/update records in DB2 tables.

我整天都在互联网上搜索有关如何安装 OLEDB 或 ODBC 驱动程序以连接到 DB2 数据库的链接.但是没有成功！！！

I spend the whole day searching over the internet for links on how to install either OLEDB or ODBC Driver in order to connect to DB2 database. But without success!!!

所以，我想知道是否有人可以帮助我或给我发送一个有用的链接来下载驱动程序.

So, i'm wondering if somebody can help me or send me a useful link to download driver.

谢谢

推荐答案

下载:

在网页中:http://www-933.ibm.com/support/fixcentral/legacy/

带参数信息管理"-IBM Data Server Client Packages"-自定义版本和平台

With parameters "Information Management" - "IBM Data Server Client Packages" - Custom version and platform

然后在Id Fix中写入*odbc_cli*

Then write *odbc_cli* in Id Fix

下载最新的修复包(在我的例子中是IBM Data Server Driver for ODBC and CLI (Windows/x86-64 64 bit) V10.5 Fix Pack 7")

Download the latest fix pack (in my case "IBM Data Server Driver for ODBC and CLI (Windows/x86-64 64 bit) V10.5 Fix Pack 7")

安装:

将 zip 复制到 C:Program FilesIBM(如果不存在，则必须创建文件夹)提取它

Copy zip into C:Program FilesIBM (if not exist, you must create the folder) Extract it

在cmd中:

执行cd C:Program FilesIBM{uncompressed driver folder}in"(默认为clidriver")

Execute "cd C:Program FilesIBM{uncompressed driver folder}in" (by default "clidriver")

执行db2cli install -setup"进行安装.如果需要卸载，执行db2cli install -cleanup"

Execute "db2cli install -setup" for install. If you need uninstall, exec "db2cli install -cleanup"

如果您需要安装它以在 64 位环境中为 32 位应用程序指向 32 位 IBM DB2 ODBC 驱动程序，请阅读此文档:http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21384435

If you need install it for pointing to 32 bit IBM DB2 ODBC driver for your 32 bit application in a 64-bit environment, read this documentation: http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21384435

注意:在 9.5.* 版本中，命令更改:安装:db2oreg1.exe -i卸载:db2oreg1.exe -u

Note: in version 9.5.* the command changes: Install: db2oreg1.exe -i Uninstall: db2oreg1.exe -u

在我看来，我建议下载带有自定义安装的 IBM Client i Access，只选择ODBC"和OLE DB Provider"

In my opinion, I recommend download IBM Client i Access with custom installation, selecting only "ODBC" and "OLE DB Provider"

您可以通过ibm public ftp下载它:public.dhe.ibm.com(端口21)在文件夹/as400/products/clientaccess/win32/v7r1m0/servicepack"中

You can download it by ibm public ftp: public.dhe.ibm.com (port 21) in the folder "/as400/products/clientaccess/win32/v7r1m0/servicepack"

这篇关于如何安装 DB2 ODBC 或 OLEDB 驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！