Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to add 32-bit data sources. There seems to be no obvious way to see existing instances of these or create new ones.

How can I open the 32-bit "ODBC Data Source Administrator" window in Windows 7 64-bit?

share|improve this question

3 Answers 3

up vote 31 down vote accepted

Run the Datasource editor from this path c:\Windows\SysWOW64\odbcad32.exe.

Ref: http://blogs.msdn.com/b/farukcelik/archive/2008/10/17/why-my-32-bit-applications-cannot-see-the-odbc-dsns-that-i-created-on-my-64-bit-machine.aspx

share|improve this answer

Just a note don't use the search box in the start menu to look for odbcad32.exe (the same as if you type odbc only). Even the name is the same it opens the one in C:\Windows\System32 not c:\Windows\SysWOW64\

Or if you want to open it from here just type the whole path in the search box to get the correct one c:\Windows\SysWOW64\odbcad32.exe

I know it because I did this mistake and I thought I was creating 32 bit DSN, but they didn't work until I found out this was the problem.

I know is confusing because is the same name file. But windows has its mysteries, or maybe there's a reasonable explanation.

Anyway just follow Zorodache answer, go to the mentioned folder and open it directly from there, and it will be fine.

share|improve this answer

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):

  • The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
  • The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

The Odbcad32.exe file displays the following types of data source names (DSNs):

  • System DSNs
  • User DSNs
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.