Thursday, May 16, 2024
HomeWindowsWindows 7ODBC Error - The specified DSN contains an architecture mismatch

ODBC Error – The specified DSN contains an architecture mismatch

This will fix a common error trying to add or configure a database source in Windows 7.

When attempting to add a new data source on my Windows 7 64-bit machine, I ran into this frustrating error. I needed to create a data source with a Microsoft Access Driver and experienced the following error:

Driver’s ConfigDSN, ConfigDriver, or ConfigTranslator failed
Errors Found:
The specified DSN contains an architecture mismatch between the Driver and Application

ODBC data source adminsitrator

This is due to the fact that Microsoft Access is a 32-bit program with 32-bit drivers which is causing the compatibility issues.

Windows 7 64-bit has two different versions of the ODBC Data Source Administrator. The ODBC Data Source Administrator that is reached through the Control Panel is the 64-bit version. What we need to do is use the 32-bit version of the ODBC Data Source Administrator instead.

1 Navigate to c:\Windows\sysWOW64\odbcad32.exe You can use the search feature as there are a lot of files in this folder if needed.


2 Double click to start the executable. You should have no problems adding the 32-bit based driver to your 64-bit machine.


Chris Luongo
Chris Luongo
Chris is a self-taught web designer and developer out of Atlanta, GA. This geek enjoys coffee, cold brews, bike riding, and twisting any form of tech into submission.


Please enter your comment!
Please enter your name here

Most Popular


Recent Comments

error: Content is protected !!