If you encounter an error message similar to "The specified DSN contains an architecture mismatch between the driver and application", then the bitness of the application you are using to attempt to connect to the data store does not match the bitness of the driver that you are using. You might be attempting to use a 32-bit driver with a 64-bit application, or or a 64-bit driver with a 32-bit application. Make sure that the bitness of your application matches the bitness of driver that you are trying to use.
Applications in Microsoft Office 2007 and earlier are 32-bit only.
To determine the bitness of an application:
For example, the following image shows the About dialog box for a 32-bit version of Microsoft Excel 2013.