This sorted my issue this post is really nice.
I followed this step to get it sorted
In order to create a 32-bit System DSN, you need to launch the ODBC manager from the following location and not just from “Administrative Tools -> Data Sources (ODBC)”:

%systemdrive%\Windows\SysWOW64\odbcad32.exe