IBM Support

CA-Datacom ODBC driver configuration

Troubleshooting


Problem

CA-Datacom ODBC drivers are installed under a user account and modifications to enable the drivers are applied to the user account only. The installation creates both a system and user DSN for your ODBC connection definition. However, the path to the driver install location is only applied to the current user account. If the Impromptu Web Reports service is running under the Local System or any other named user account then they will not have the drivers listed in their PATH environment variable.

Symptom

Unable to Log on to database

or

Specified driver could not be loaded due to system error 126 (CA-Datacom/DB).

Resolving The Problem

To allow use of the drivers by other user accounts, change your system environment variable PATH to include the install location of the CA-Datacom drivers.

Steps:
  1. Access the System entry from your Control Panel.
  2. Select the Advanced tab.
  3. Click the Environment Variables button.
  4. In the System Variables section select the PATH variable.
  5. Click the Edit button.
  6. At the end of the PATH variable value place a semi-colon character to indicate a new entry and then add the path to your CA-Datacom install location, ie. "C:\CA_APPSW"
  7. Reboot the system in order for the changes to take effect.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu Web Reports","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Impromptu 7.4;Impromptu Web Reports 7.0;Impromptu Web Reports 7.1;Impromptu Web Reports 7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Impromptu Web Reports","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1005162

Document Information

Modified date:
15 June 2018

UID

swg21349768

Page Feedback