Common Error Fixes
The specified DSN contains an architecture mismatch
If you receive this error or something similar (i.e ""The specified DSN contains an architecture mismatch between the driver and application") this tends to mean that the driver you are using to connect to the datasource is either 32-bit or 64-bit and office or visual studios is running the opposite (i.e. 32- bit connector and 64 bit visual studio).
If you are running the report through the RESTful Engine this can be easily fixed through IIS.
If the connector and office are running 32-bit and you get this error we can enable IIS to run 32 bit applications. First open up IIS and navigate to Application Pools
Next right click on which application pool your RESTful Engine is using (most likely .NET v4.5) and then click Set Application Pool Defaults. This will open a window with a bunch of properties. At the top under General is the property Enable 32-Bit Applications, we want to set that value to True.
After that, you can click OK and you should be all setup to use 32-bit applications and drivers in your RESTful Engine.