oracle odbc driver architecture

1. Issue:
Oracle ODBC driver was installed and DSN was configured and test connection was succeed. But it gave error when you try to use the DSN through MS Excel or MS Access 2007.

2. Error:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
3. Root Cause:
ODBC driver installed is 64 bit because OS is Win 7. MS Excel or MS Access 2007 is 32 bit. So the platforms are mismatched.

4. solution:
4.1 install 32bit ODBC driver
4.2 run C:\windows/sysWOW64\odbcad32.exe
4.3 configure DSN
4.4 use the conifured DSN in MS Excel or MS Access 2007


reference:
https://forums.oracle.com/forums/thread.jspa?messageID=10327205
http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362(v=vs.85).aspx
https://forums.oracle.com/forums/thread.jspa?messageID=9726983