Category:ODBC
Last Updated:2011-09-26
On your Windows 2008 Server, when running the
Admin Tools > Data Source (ODBC)
... it runs the 64 bit version of the ODBC Data Sources.
SimpleSync uses the 32 bit version of ODBC.
This requires the Oracle client be installed first.
Then, on the Windows 2008 Server, go to a cmd prompt and run odbcad32.exe.
%systemdrive%\Windows\SysWoW64\odbcad32.exe
Recreate the desired System DSN.
Then return to SimpleSync. You should see the DSN is now available...
Reference this article for other details:
http://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/