ODBC Error - The Configuration Process failed

antz_h 1 Reputation point
2021-05-17T13:58:05.743+00:00

I'm unable to create a new System DSN entry / ODBC 64 bit

Using a MS Azure VM server
Error "The configuration process failed".
When you cancel another message says "Drivers ConfigDSN, ConfigDriver, or ConfigTranslator failed. Errors found: Could not write to registry"

Driver is Microsoft Access Driver (*.mdb, *.accdb) version 16.00.13929.20192 ACEODBC.DLL

Have Googled the error to death but to no avail.

Can anyone help?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,815 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
825 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,606 Reputation points
    2021-05-19T02:58:51.247+00:00

    Hi,

    As far as I know, Microsoft Access Driver is used to connect to Access, so this problem is more related to Access. But notice that you added a tag for the SQL Server database. Please let me know if I misunderstood something.

    >Drivers ConfigDSN, ConfigDriver, or ConfigTranslator failed. Errors found: Could not write to registry

    This looks like a permissions issue.
    Windows stores the SYSTEM ODBC data source under HKEY_LOCAL_MACHINE\Software\ODBC. It seems that the current user does not have administrator rights and cannot write information to the registry.

    Try to create a User DSN or use "Run as administrator" to run ODBC Data Sources.