I had a problem where I would create data sources in BIDS but they wouldn’t show up in the ODBC administrator. Today I learned that there are 2 ODBC administrator programs…one 32-bit and one 64-bit. The 32-bit system files folder is called SysWOW64. The 64-bit folder is called System32. Of course it is. (WOW stands for Windows On Windows.) Making things worse is the fact that the 64-bit ODBC administrator executable is also called odbcad32.exe.