Run IIS in 32 bit mode
In order to connect to Excel or via ODBC, it may be necessary to install 32-bit drivers on your Dundas BI server. For example, some ODBC drivers are only available in 32-bit as opposed to 64-bit.
This article shows you how to run your Dundas BI IIS application pool in 32-bit mode so that the 32-bit drivers will function correctly with Dundas BI.
2. Run your application pool in 32-bit mode
In IIS 7, each application pool has a setting to run as 32-bit or 64-bit individually.
To check or change this setting, first launch IIS Manager.
Select Application Pools in the Connections pane.
Select Dundas BI (InstanceName) in the Application Pools pane.
Click Advanced Settings in the Actions pane.
Set the Enable 32-Bit Applications setting to True. Click OK.