You are trying to connect from 32bit to 64bit drivers or 64bit to 32 bit.
Make sure the DSN you create is present in both the 64 bit and 32bit ODBC's.
Add the DSN to 32bit ODBC using c:\Windows\SysWOW64\odbcad32.exe.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle