Runnning a 32-Bit Web Application on a 64 bit Windows

When you have a Web application that uses a 32 bit database driver to access a database , eg ms access. You have to

1. Use the 32-bit ODBC Manager (%windir%\syswow64\odbcad32.exe) to create the DSN
2. Run the WebApplication in a 32 bit Application Pool

Run IIS Admin, create a new Application Pool (use Classic). Advance settings - Enabled 32 bit application -TRUE