IBM Support

ODBC Driver for IBM i Access Client Solutions

Question & Answer


Question

How do I get the ODBC driver for IBM i Access Client Solutions?

Answer

IBM i Access Client Solutions (ACS) is split into two main parts. The base package component is the Java-based client that includes the emulator, data transfer, and other functions with graphical interfaces. The other part are the platform-specific packages which are the Windows Application Package, the Linux Application Package, and the macOS Application Package.

The Windows Application Package component contains the ODBC driver, OLEDB provider, ADO.Net provider, ActiveX components, and API support ported from the older IBM i Access for Windows client.

The Linux and macOS Application Packages provide an ODBC driver that works with the unixODBC project. This product replaces the older Linux client with a new and greatly improved ODBC driver.

Note: At the time of this writing, MS Excel for Mac does not integrate with the required unixODBC project library.

The 'Downloads for IBM i Access Client Solutions' link on the IBM ACS home page provides a simple way to download the base client, the Linux and macOS ODBC driver packages, and the Windows Application Package for English 64-bit systems.  To get other Windows languages or an installation image for a 32-bit Windows system, download them through IBM's Entitled Systems Support (ESS) or request the product from your IBM Business Partner.  For more information about downloading the clients from ESS, see the instructions in technote, Obtaining IBM i Access Client Solutions.

The IBM ACS ODBC driver is designed to access all currently-supported versions of OS400.

[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Access Client Solutions","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 August 2020

UID

nas8N1022156