When trying to add any sort of IQD data source in a new model, or opening a preexisting model that used to work on another machine :
(TR1008) Transformer couldn't read the connection information
for database <Database> from COGNOS.INI, from IBM Cognos Impromptu
Query Definition (IQD) Runtime Gateway location, or from the IQD file.
Cogtr.exe crashes in module msvcr100.dll
This document cover the case when Series7 IQD Bridge is correctly installed, and the [Databases] section has been added and correctly filled in cs7g.ini configuration file.
The DATABASE name from the IQD is correctly defined in cs7g.ini, using the exact same name.
Missing MFC41.dll on the system.
The Transda.exe process, that is handling IQD files, does not find MFC41.dll in any locations specified in the PATH variable, and thus the process is exiting.
Resolving the problem
MFC41.dll is a Microsoft library that is not installed by default on Windows, but may be installed by some optional Microsoft components or third-party softwares. Installing Windows Data Access Component (WDAC, formerly MDAC) may work. Otherwise, contact Microsoft Support to find out how to get this file.
Another solution is to search for this file on another existing machine, then copy it and paste it into either:
- \ibm\cognos\c10\CS7Gateways\bin directory
- C:\Windows\system32 on a 32-bit system
- C:\Windows\SysWow64 on a 64-bit system