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:
o | IBM.Data.DB2.DB2e.CF is intended for the .Net Compact Framework |
o | IBM.Data.DB2.DB2e is intended for the .NET Framework |
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.
Historical Number
329837186
Was this topic helpful?
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