KB248808: “An error occurred while creating the DSN...” error messages occurs when creating a DSN to a Microsoft Access database using Connectivity Wizard in MicroStrategy 10

• Strategy

“An error occurred while creating the DSN...” error messages occurs when creating a DSN to a Microsoft Access database using Connectivity Wizard in MicroStrategy 10

SUMMARY:
The issue described in this document has been classified as a defect by Strategy. The issue occurs in Strategy 10 when using Connectivity Wizard to connect to a Microsoft Access database. A workaround is available in the current document. A solution/code fix for this issue is not available in current releases, but is being review for a future Strategy release.

DESCRIPTION / SYMPTOM:
In Strategy 10 when users try to create a DSN to connect to a Microsoft Access database in Connectivity Wizard, the following error message appears:


An error occurred while creating the DSN:Error in finding the DSN:RegistrySmartHKey::RegistrySmartHKey - ::RegOpenKeyEx returned an unexpected error code

CAUSE:
This is a known issue in Strategy 10 when connecting to a Microsoft Access database.

ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.

WORKAROUND:
Use the Windows ODBC administrator to create a 32-bit DSN to connect to a Microsoft Access database.

Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 9, 2017