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.

odbcad32.exe

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

odbc32

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.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!