Windows 7 64bit ODBC Data sources

less than 1 minute read

Today I was trying to create and ODBC Data Source to a database using 32 bit database drivers. When I accessed ODBC Data Sources (32bit) from Control Panel, I could not create a data source using 32 bit drivers and I was facing two Driver not found errors which can be seen in the following screenshots.

odbc administrator error reinstall driver - Database Driver not found error

odbc architecture mismatch between driver and application error Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed error

After searching in web and querying my colleagues I found that when you want to use Microsoft ODBC Administrator for:

  1. 64bit database drivers you have to run the 64bit version which is located in: C:\Windows\System32\odbcad32.exe
  2. 32bit database drivers you have to run the 32bit version which is located in: C:\Windows\SysWOW64\odbcad32.exe

Both windows look identical but the underlying implementation is different.

Comments

You May Also Enjoy