

- IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER HOW TO
- IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER DRIVERS
- IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER DRIVER
- IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER PC
System DSNs that are created with 64-bit ODBC Administrator will only work with the 64-bit Driver. When running on 64-bit Windows, User DSNs will work with either driver.
IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER DRIVER
The version of the driver manager (odbc32.dll) determines to which driver the ODBC calls get routed. The driver name in both cases is iSeries Access ODBC Driver.
IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER PC
Similarly, the 64-bit ODBC driver that is installed with iSeries Access for Windows on a 64-bit Windows PC is \windows\system32\cwbodbc.dll and the 32-bit driver is \windows\SysWOW64\cwbodbc.dll. This does not apply just to ODBC related files. Note: All available information indicates that all 64-bit files are stored in System32 and all 32-bit files are stored in SysWOW64. The \windows\SysWOW64\odbcad32.exe is the 32-bit ODBC Administrator. The \windows\system32\odbcad32.exe is really the 64-bit ODBC Administrator. Some things in 64-bit Windows are the opposite of what you would expect. One would think that the 32-bit system files would go in the System32 directory and the 64-bit system files would go in the SysWOW64 directory. Both versions can be accessed from the iSeries Access for Windows folder.Ħ4-bit Windows has the familiar C:\Windows\System32 directory, and it also has a C:\Windows\SysWOW64 directory that serves a similar function as a repository for system files.
.jpg)
Both versions are named odbcad32.exe (there is no odbcad64.exe). Microsoft provides the following versions of the ODBC Administrator: 32-bit and 64-bit. ODBC applications running in 64-bit versions of Windows will automatically use the appropriate ODBC driver, depending on whether the application was compiled as 32-bit or 64-bit. The 64-bit ODBC driver is automatically installed along with the 32-bit ODBC driver when running under a 64-bit version of Microsoft Windows. The Client Solutions Application Packs are available from IBM’s Entitled Systems Support (ESS) website and (as of the writing of this article) from the Client Solutions download page.IBM iSeries Access for Windows provides both a 32-bit and 64-bit ODBC driver. Most of these items aren’t ever needed by end users, but if you’re a developer looking for something that’s gone missing it is very likely in one of these packages.

The Windows package also includes the AFP printer driver and a number of other database connectivity and development tools.

IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER DRIVERS
Both the Windows and Linux packages include ODBC drivers for their specific platforms. These optional packages contain the platform-specific installable components of IBM i Access that are no longer part of the base package. The ODBC drivers and a few other things fall under this category, and needed to be separated out from the Java applications so they could be given special handling.Įnter the Client Solutions Application Packages for Windows and Linux. It doesn’t use a traditional installation method for setup, so it cannot account for anything that might need to be installed on the PC in an OS-dependent way. The Client Solutions base package, which includes the 5250 emulator and even the SQL scripting tools, is a platform-independent Java application. There are actually a number of pieces to the IBM i Access puzzle that are nowhere to be found in the base ACS “installation,” so I thought I’d take a minute to revisit how ACS is structured by IBM for those who might be looking for something specific.
IBM I ACCESS CLIENT SOLUTIONS ODBC DRIVER HOW TO
I’ve been asked several times in the last few weeks about ODBC drivers for IBM i and how to obtain them for a PC running Client Solutions.
