IBM Support

TR1008 Transformer couldn't read the connection information
for database <Database>...

Troubleshooting


Problem

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 from COGNOS.INI, from IBM Cognos Impromptu Query Definition (IQD) Runtime Gateway location, or from the IQD file. or 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.

Cause

Missing MFC71.dll on the system.
The Transda.exe process, that is handling IQD files, does not find MFC71.dll in any locations specified in the PATH variable, and thus the process is exiting.

Resolving The Problem

MFC71.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

or

- C:\Windows\system32 on a 32-bit system

or

- C:\Windows\SysWow64 on a 64-bit system

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Transformer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2;10.1.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21647866