32bit App – 64bit OS ODBC Problem

Problem:
ODBC data sources that are created with the “ODBC Data Source Administrator” located under “Administrative Tools > Data Sources (ODBC)” do not show up in 32 bit (x86) applications. Also, data sources created in 32 bit applications such as Visual Studio do not show up in the “ODBC  Data Source Administrator”. This is due to the default shortcut for the “ODBC Data Source Administrator” being for 64 applications only.

Solution:
Create an additional shortcut in Administrative Tools named “Data Sources (ODBC) x86” that points to “C:\Windows\SysWOW64\odbcad32.exe” (the 32bit version of “ODBC Data Source Administrator”) for managing data sources for 32 bit applications.

ODBCx86

On a 64 bit OS, the SysWOW64 folder contains 32 bit versions of exe’s and dll’s.

µ

Leave a Reply

%d bloggers like this: