.NET DB2 OLEDB先决条件

本文介绍了.NET DB2 OLEDB先决条件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我在C＃.NET Framework 2.0中编写了一个Windows Forms应用程序，它使用 System.Data.OleDb 与SQL Server 2000数据库进行通信，该数据库正在工作精细。现在，我需要加强应用程序，以便在 AS / 400 。这是仅仅是配置连接字符串的问题，还是需要额外的驱动程序软件（在哪里）和/或项目中的引用？

我还想使用OLEDB，但使用DB2。

编辑：我下载了 Microsoft OLE DB提供程序，但无法将其安装到我的桌面开发PC上，因为我没有安装SQL Server。这个提供商似乎只用于将SQL Server与DB2集成，而我想将Windows Forms应用程序与DB2集成。对于不需要SQL Server的OLE DB提供程序，是否有不同的下载位置，可以从Windows桌面使用？

解决方案

p>您可以使用Microsoft的 OLEDB for DB2提供商。另外连接字符串也会改变。

喜欢：

Provider = DB2OLEDB;网络传输库= TCPIP;网络地址= xxx.xxx.xxx.xxx;初始目录= MyCtlg;包集合= MyPkgCol;默认模式=模式;用户ID = myUsername;密码= myPassword;

或者您可以使用IBM自己的适用于DB2的IBM OLE DB提供程序，无需SQL Server即可。

您应该查看 IBM DB2的连接字符串 所有其他提供商及其配置。

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?

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

Edit: 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?

解决方案

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

Like:

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;

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

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