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

4 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android