Showcase iSeries ODBC Driver Not Loaded Due to System Error

Abstract

Error received trying to add Showcase ODBC iSeries driver in MS ODBC Administrator: 'Setup routine for the Showcase iSeries ODBC Driver could not be loaded due to system error code: 126'. After selecting OK twice, then receives error: 'Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed - Could not load the setup or translator library'.

Solution

Verify that the Environmental PATH variable is correct. Follow tthe steps below to retrieve the Environment Variable PATH Statement:

1. In Start\ Settings\Control Panel select the System option and go to the Advanced tab.
    
2. Click on Environment variables. In the System Variables window find and highlight the 'Path' entry. There are several entries with the word 'path' in them but there should only be one named simply 'PATH'. Highlight this entry and then click on the Edit button.
    
3. Within the Edit window, the entire path should be highlighted by default when the dialog first opens.  Hit Control + C to copy the entire path to the clipboard and paste it into any text editor such as Notepad or Word.
    
4. Verify the PATH Statement. The Environmental PATH statement should look like the following.

For ShowCase versions 7.x and 8.x:

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SystemRoot%\system32\nls;%SystemRoot%\system32\nls\ENGLISH;C:\Program Files\Novell\ZENworks;C:\Program Files\IBM\Client Access;C:\ProgramFiles\IBM\Client Access\Shared;C:\Program Files\IBM\Client Access\Emulator;;C:\Program Files\ShowCase Suite\Bin;C:\Program Files\ShowCase Suite\JRE\bin;C:\Program Files\ShowCase Suite\JRE\bin\client;

For IBM ShowCase version 9.x:

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Intel\DMIX;C:\Program Files\IBM\Client Access;C:\Program Files\IBM\Client Access\Shared;C:\Program Files\IBM\Client Access\Emulator;;C:\Program Files\IBM\ShowCase\9\bin;C:\Program Files\IBM\ShowCase\9\JRE\jre\bin;C:\Program Files\IBM\ShowCase\9\JRE\jre\bin\j9vm;C:\Program Files\IBM\Client
Access;C:\Program Files\IBM\Client Access\Shared;C:\Program Files\IBM\Client Access\Emulato

Ref#: 1484271