Unable to Create a Data Source on Windows 7, 64-bit

 

Problem Statement:

Unable to create a data source on Windows 7 64-bit.

Error: Microsoft ODBC Administrator The setup routines for the IBM ShowCase IBM i Driver ODBC driver could not be loaded due to system error code 126: The specified module could not be found. (C:\Program Files (x86)\IBM\ShowCase\9.0\bin\scojdbc.dll).

Solution:

Issue was due to  Msvcr71.dll (Microsoft C Runtime Library) file is missing in the C:\Windows\SysWOW64 directory.
To resolve the issue:

• Copy the Msvcr71.dll file from a working PC to the C:\Windows\SysWOW64 directory on the failing PC
• Open Microsoft ODBC Administrator to create your data-source connection to the ShowCase server.

Note:

• On a Windows 7 - 32-bit machine, you will have to copy the file to the directory c:\windows\sytem32
• This seems to be an issue with Windows, if you search the web you find many instances of this issue. If you do not have a working PC you should be able to find a free download of the  Msvcr71.dll file as well.

Ref#: 1486988