IBM Support

IBM .Net Data Providers for IBM DB2 UDB for iSeries

Troubleshooting


Problem

This document describes the .NET data providers available to connect to IBM System i systems.

Resolving The Problem

IBM supplies the following .Net data providers that can be used with the IBM System i systems.

The IBM DB2 UDB for iSeries .NET data provider (IBM.Data.DB2.iSeries) is supplied with the IBM i Access for Windows product. The iSeries .NET provider is specific to DB2 UDB for IBM i. It cannot be used to connect to other DB2 platforms. In general, it provides slightly better performance than the other .NET providers. It also provides access to enhancements specific to the iSeries system. Developers looking for a low cost, high performance .NET connection specific to the iSeries platform should consider using this provider.

An additional provider is the IBM.Data.DB2 managed provider. This provider is part of DB2 UDB and DB2 Connect Version 8.1.3 or higher. The IBM.Data.DB2-managed provider can be used with all DB2 platforms. In addition to the data provider, this product also includes the IBM DB2 Development Add-Ins for Visual Studio .Net. This feature is a set of tightly integrated application development, administration tools, and wizards specifically designed for this provider. Developers looking for a DB2 cross-platform solution or full function Microsoft Visual Studio .NET development tools should consider this provider.

This provider is supplied as part of the DB2 Everyplace product. The following providers are included in the product:

oIBM.Data.DB2.DB2e.CF is intended for the .Net Compact Framework
oIBM.Data.DB2.DB2e is intended for the .NET Framework
This provider should be considered by developers working on .NET applications for mobile devices such as personal digital assistants (PDAs) and smart phones.

In addition to the managed providers listed above, existing ODBC and OLEDB providers for the IBM i system can be accessed through one of the .NET interoperability layers. Microsoft provides an ODBC .NET managed data provider and an OLE DB .NET managed data provider. These providers allow ADO .NET applications to access data through existing ODBC drivers or OLEDB providers. .NET also supports using ADO 2.7 through a communications interoperability layer.
[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Access","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Historical Number

329837186

Document Information

More support for:
IBM i

Software version:
Version Independent

Operating system(s):
IBM i

Document number:
639345

Modified date:
18 December 2019

UID

nas8N1016227

Manage My Notification Subscriptions