IBM i Access

PC5250

Description of the PC5250 path changes made in V6R1..

Learn more

Operations Console

  • Known problems
  • Operations Console support

Learn more

ODBC driver

What is the ODBC driver?

The IBM i Access for Windows 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 for Windows ODBC driver conforms to the Microsoft ODBC 3.5 specification.

Refer to the following resources for details:

IBM i Access for Windows database sample program

ODBC topic in the IBM i InfoCenter

What's new

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

  • Support for the IBM i XML data type
  • Support for longer SQL schema names
  • Connection property to configure the Concurrent Access Resolution
  • Support for multi-row UPDATE, DELETE, and MERGE statements

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

Learn more

OLE DB support

  • Are you looking for a way to get your programmers started in the world of client/server programming?
  • Are you an RPG programmer that is migrating to PC development?
  • Would you like record level access to your DB2 for i database from PC tools?
  • Wouldn't it be nice if you could use a common language to access all types of data rather than calling special APIs for each?
  • Do you wish you could have someone show you how to write ActiveX Data Object (ADO) code to get at IBM i server data and services?
  • Would your business do better if you could spend time on solving customer problems instead of worrying about the complexities of client/server computing?

Our IBM i Access OLE DB Support is the answer

Our support consists of the following products and components.

  • IBM i Access for Windows OLE DB Provider
  • IBM i Access for Windows Toolkit

XDA

Description of each EDRS API

Learn more

Contact IBM

Browse Power Systems

Close [x]

Advantages

Companies embracing Smarter Computing are implementing IT infrastructure based on the IBM Power Systems platform that is designed for data, tuned to the task and managed with cloud technologies. With Power Systems, businesses can outpace their competitors by delivering services faster, differentiate their offerings by delivering higher quality services, and turn operational cost into investment opportunity by delivering services with superior economics.

Close [x]

Hardware

Power Systems hardware provides the foundation for designing workload optimized systems in conjunction with software and expert domain knowledge. Power servers and blades are modular and scalable and designed from the chip through the software stack to help deliver new levels of business performance.

Close [x]

Operating systems

Power servers deliver flexibility and choice of operating systems to enable your business to select the best applications for your business needs. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

Close [x]

System software

IBM's integrated approach to developing Systems and Systems Software stacks together delivers maximum utilization, availability, and flexibility helping you deliver new advantages in your business.

Close [x]

Solutions

IBM and IBM Business Partner solutions exploit key benefits in Power Systems that help you deliver new capabilities and new competitive advantages to your business.

Close [x]

Migrate to Power

Over the last five years thousands of clients have migrated to POWER. Learn how Power Systems has helped them improve their business performance, reduce risk, and establish a more secure future.

Quick links

Additional information