The IBM-supplied ODBC driver you use will depend on your needs. Some shops also use ODBC drivers from Microsoft and other companies to access IBM i data, but today let’s focus on IBM’s drivers. Step #1: Downloading Windows ODBC driversįor IBM i ODBC access from a Windows machine, companies generally use these ODBC drivers: Here’s how these pieces fit together for Windows ODBC access to IBM i data, and where you can run into problems using ODBC. Use your DSN to access IBM i data on a Windows program.Create an ODBC Data Source Name (DSN) configuration for accessing IBM i data on your Windows system.

If you’re not familiar with using ODBC for accessing IBM i data on Windows systems, you only need to perform three steps to import IBM i data into your Windows programs:

Since the 1990s, Windows users have been using ODBC to import IBM i data into application programs such as Microsoft Excel, or into custom-written Windows programs. The Open Database Connectivity (ODBC) API is one of the oldest and most widely used ways for Windows users to access and modify data on any system, including IBM i data.

Download ibm client access 7.1