.NET DB2 OLEDB 先决条件

本文介绍了.NET DB2 OLEDB 先决条件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我用 C# .NET 框架 2.0 编写了一个 Windows 窗体应用程序，它使用 System.Data.OleDb 与 SQL Server 2000 数据库通信，运行良好.我现在需要增强应用程序，以便与 DB2 数据库上的 AS/400.这只是配置连接字符串的问题，还是我需要额外的驱动程序软件(来自哪里)和/或我的项目中的引用?

I have written a Windows Forms application in C#, .NET framework 2.0, that uses System.Data.OleDb to talk to an SQL Server 2000 database, which is working fine. I now need to enhance the application to talk to an DB2 database on AS/400. Is this just a matter of configuring the connection string, or do I need additional driver software (where from) and/or references in my project?

我仍想使用 OLEDB，但使用 DB2.

I would like to still use OLEDB, but with DB2.

我下载了 Microsoft OLE DB Provider 但无法将其安装到我的桌面开发 PC 上，因为我没有安装 SQL Server.该提供程序似乎仅用于将 SQL Server 与 DB2 集成，而我想将 Windows Forms 应用程序与 DB2 集成.不需要 SQL Server 的 OLE DB 提供程序是否有不同的下载位置，我可以从 Windows 桌面使用它?

I downloaded the Microsoft OLE DB Provider but was unable to install it onto my desktop development PC because I do not have SQL Server installed. This provider seems to be only for integrating SQL Server with DB2, whereas I want to integrate a Windows Forms application with DB2. Is there a different download location for an OLE DB provider that does not require SQL Server, which I can use from a Windows desktop?

推荐答案

你可以使用微软的OLEDB for DB2 提供程序 用于此.连接字符串也会改变.

You will can use Microsoft's OLEDB for DB2 provider for this. Also the connection string will change.

喜欢:

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;

或者你可以使用IBM自己的IBM OLE DB Provider for DB2 无需 SQL Server 即可工作.

Or you can use IBM's own IBM OLE DB Provider for DB2 that works without SQL Server.

您应该查看 IBM DB2 的连接字符串其他提供者及其配置.

You should look at Connection strings for IBM DB2 for all other providers and their configuration.