IBM Support

"CCA3054N The ODBC DSN could not be registered" when adding a database from Configuration Assistant on Windows Vista, 7, or 2008

Troubleshooting


Problem

"CCA3054N The ODBC DSN could not be registered" when adding a database from Configuration Assistant on Windows Vista, 7, or 2008

Symptom

When trying to add a database using the Configuration Assistant on Windows Vista, 7, or 2008, the CCA3054N error will occur if the option to create a system DSN was selected during the add database wizard.

Cause

The error is caused by the Microsoft UAC (User Account Control) feature included in Windows Vista, 7, and 2008. In order to create a system DSN, local administrative privileges are required. Even if the logon user is a local administrator, the UAC feature causes the logon user to only include the standard user token. As a result, Configuration Assistant will not be able to detect the administrative authority and the process of trying to add the system DSN will fail.

Resolving The Problem

To resolve the problem, the Configuration Assistant must be explicitly launched with administrative privileges. To do this, right-click on the Configuration Assistant icon in the start menu and select the option to "Run as Administrator". Once the Configuration Assistant is launched, retry the previous steps that caused the CCA3054N error and it should complete successfully and create a system DSN on the machine.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Programming Interface - ODBC","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21575269