Updating odbc driver

11-Oct-2019 08:06

When creating a new data source name (DSN) on a Microsoft Windows 32-bit system to access the i Series server that hosts Lotus Enterprise Integrator (LEI), you do not see the i Series Access ODBC driver listed as an available driver. The IBM i Series Access for Windows client isn't listed if it is not installed on the 32-bit system.

Windows 32-bit systems will not normally show an ODBC driver option for i Series when creating a new DSN via the ODBC Data Source Administrator tool.

For Windows installations, you can download version 17.2 of the Microsoft ODBC Driver 17 for SQL Server here. For installation details see the online instructions.

We are committed to improving quality and bringing more feature support for connecting to SQL Server, Azure SQL Database, Azure SQL DW, and Azure SQL Managed Instance through regular driver releases.

This product replaces the older Linux client with a new and greatly improved ODBC driver.

To get these additional components, you must either download them through IBM's Entitled Systems Support (ESS) using the instructions in our technote, Obtaining IBM i Access Client Solutions or you can request the product from your IBM Business Partner if that is where you obtain your IBM i software.

I'm currently running MS ODBC for Oracle ver 2.5xxxxx. We used to use some Oracle8.1 ODBC drivers for some third-party apps when we had an Oracle8.1 database, but when we upgraded our database to Oracle9, we had to also upgrade at least some of our ODBC drivers to the Oracle9 ODBC driver.

The application will not be impacted (unless there are database specific query/commands). When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.That information, along with your comments, will be governed by DISQUS’ privacy policy.(IBM does not plan to support IBM i Access for Windows on operating systems beyond Windows 8.1.The replacement product is IBM i Access Client Solutions (ACS), which includes 5250 emulation, data transfer, printer output, console support, and more.

The application will not be impacted (unless there are database specific query/commands). When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.That information, along with your comments, will be governed by DISQUS’ privacy policy.(IBM does not plan to support IBM i Access for Windows on operating systems beyond Windows 8.1.The replacement product is IBM i Access Client Solutions (ACS), which includes 5250 emulation, data transfer, printer output, console support, and more.Think of it as Access for Windows without the graphical interfaces.