.NET DB2 OLEDB pre必备

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

我写了一个Windows窗体应用程序在C＃，.NET Framework 2.0中，使用 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提供程序，但无法安装到我的台式PC的发展，因为我没有安装SQL Server。该供应商似乎只是为了与DB2集成的SQL Server，而我想整合Windows窗体应用程序使用DB2。是否有不同的下载位置OLE DB提供程序不需要的SQL Server，这是我可以从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的DB2提供商这一点。另外，连接字符串会有所改变。

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

像：

提供商= DB2OLEDB;网络传输库= TCPIP;网络地址= xxx.xxx.xxx.xxx;初始目录= MyCtlg;包集合= MyPkgCol;默认架构=架构;用户ID =名为myUsername;密码= 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提供程序用于DB2 的作品没有SQL服务器。

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.