Visual Studio application with 32 bit ODBC connection fails to run

If you are publishing a Visual Studio application that uses a 32 bit ODBC connection or otherwise accesses a 32 bit application on a 64 bit OS it will fail to run unless you change an Application Pool Setting in IIS .

To do this you will need to complete the folloing steps.

1. Open the Internet Information Services (ISS) Manager by clicking on Start > Control Panel > Administrative Tools > Internet Information Services (ISS) Manager.
2. Click the '+' icon next to the name of the webserver to expand display the Application Pools and Sites.
3. Click on 'Application Pools.'
4. In the Application Pools window pane click on the name of your application.
5. In the Actions window pane locate and click on 'Advanced Settings...'
6. You will then be presented with the Advanced Settings window. Under 'General' locate the option named 'Enable 32-Bit Applications and set it's value to 'True.'
7. Click the OK button.

Retry your application and it should now be functional