ODBC driver

What is the ODBC driver?

The IBM i Access ODBC driver provides SQL access to IBM i database files, using standard ODBC interfaces. Applications developed according to the ODBC specification can be used to access data from any database management system (DBMS) which provides an ODBC driver. This eliminates the need to code to multiple proprietary database interfaces. The IBM i Access ODBC driver conforms to the Microsoft ODBC 3.5 specification.

Refer to the following resources for details:

What's new

These are the enhancements that were added to the ODBC driver in the 7.1 release:

.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.

OLE DB support

Our IBM i Access OLE DB Support is the answer

Our support consists of the following products and components.


Description of each EDRS API

Contact IBM

  • Call IBM Support Line:
    1-800-IBM-SERV (1-800-426-7378)1-800-426-7378
    Inside the US

To draw insights and make better decisions, businesses rely on the secure, flexible and open platform of IBM Power Systems. Built with the first processor designed for big data workloads, the design of Power Systems combines the computing power, memory bandwidth and I/O in ways that are easier to consume and manage, building on strong resiliency, availability and security.

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.

Transform your business with Systems Software that enables virtualization, high availability, flexibility, security and compliance on Power Systems™. IBM’s integrated approach to developing Systems and Systems Software together delivers optimized results with Power Systems.

As an open innovation platform, Power Systems is optimized for big data and analytics performance and to deliver scale-out economics and security for the cloud. IBM and IBM Business Partner solutions exploit key capabilities in IBM Power Systems.

Over the last five years thousands of clients have migrated to IBM Power Systems for choice and flexibility. Learn how Power Systems has helped them revolutionise the way IT is developed and delivered, optimise for big data and analytics, and support private, public and hybrid offerings for scale-out or scale-up implementations all while improving business performance, reducing risk, and establishing a platform for growth.

Quick links

Additional information