IBM i Access for Windows

.NET provider

What is the .NET Data Provider?

The IBM DB2 for i .NET provider (named IBM.Data.DB2.iSeries) allows Windows applications to use the Microsoft .NET Framework to access DB2 for i databases.

What versions of .NET Framework are supported by the .NET Provider?

The 5.4 version of the .NET Provider targets the Microsoft 1.0 / 1.1 .NET Framework. For information about getting started with the 5.4 .NET provider, a handy reference is the Redbook Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET. While the 5.4 provider works with newer versions of the .NET Framework, none of the new features from the 2.0 or later Framework are available when using the 5.4 provider.

The 6.1 and 7.1 versions of the .NET Provider target the Microsoft 2.0 Framework. The 2.0 Framework provides the System.Data.Common base class model, allowing ADO.NET applications to implement provider-independent code more easily. While support for the newer Entity Framework is not provided, applications written to the 2.0 specification will run on newer .NET Framework versions without modification.

What's new?

The 7.1 .NET Provider includes these enhancements:

Where can I find more information?

The IBM DB2 for i .NET Provider Technical Reference includes a full description of the provider classes and data types, and includes usage notes on many topics. The Technical Reference is part of the IBM i Access for Windows Programmer's Toolkit, an optionally installed feature of the IBM i Access for Windows product. Be sure that you have the Programmer's Toolkit (Headers, Libraries, and Documentation) feature installed on your PC, then find a link to the Technical Reference here:

IBM i Access for Windows > Programmer's Toolkit > .NET Provider Technical Reference

What's the next step?

To ensure you get the most out of the IBM DB2 for i .NET Provider, the most recent IBM i Access for Windows service pack should be installed.

Contact IBM

Browse Power Systems

Next generation applications for big data and analytics and cognitive computing are providing unprecedented insights into opportunities, threats and efficiencies. IBM Power Systems is at the forefront of delivering solutions to gain faster insights from analyzing both structured information and unstructured big data. With the secure, flexible and open platform of IBM Power Systems plus solutions and software, organizations can outpace their competitors by delivering faster services, providing differentiated offerings and turning operational cost into investment opportunity.

IBM Power Systems hardware is at the heart of enabling major business and industry transformations fueled by the explosive growth of big data and analytics. Power Systems help organizations drive faster business insights with industry leading performance, scalability and virtualization flexibility.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

IBM's integrated approach to developing Systems and Systems Software stacks together delivers a platform that supports next generation applications for big data and analytics and cognitive computing on an open platform for choice while providing maximum utilization, availability, and flexibility to help you deliver new advantages to your business.

IBM and IBM Business Partner solutions exploit key benefits in IBM Power Systems’ unique design combined with systems software to provide support for next generation applications for big data and analytics and cognitive computing to providing unprecedented insights into opportunities, threats and efficiencies to your organization.


Over the last five years thousands of clients have migrated to IBM Power Systems. Learn how Power Systems has helped them support next generation applications for big data and analytics and cognitive computing on an open platform for choice while improving business performance, reducing risk, and establishing a platform for growth.