The following are different scenarios I tried:
Enable 32-bit = False
Result: Pages without Access DB connection load fine.
If a page has ASP code with ODBC connection, then error (500 Internal server error There is a problem with the resource you are looking for, and it cannot be displayed.) on remote Browser.
On local browser (I.E. on the server), the error is
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Failed Request Tracing shows:
ErrorCode 800a0e7a
Description Provider cannot be found. It may not be properly installed.
My note: The above error seems to point to ODBC or OLE DB problem.
Then I set AppPool Enable 32-bit = True
Result: AppPool stops as soon as a web page (any page, html or asp) is accessed from a browser. HTTP Error 503. The service is unavailable.
Windows System log: Application pool 'xxx' is being automatically disabled due to a series of failures in the process(es) serving that application pool.
Windows Application Log: The Module DLL C:\Windows\system32\RpcProxy\RpcProxy.dll failed to load. The data is the error. (5 times)
Now I add preCondition="bitness64" in applicationHost.config file next to RpcProxy.dll Globalmodules
Result: The specified module could not be found. (0x8007007e) for every page including simple html page.
Failed Request Tracing shows:
ModuleName StaticCompressionModule
Notification 16
HttpStatus 500
HttpReason Internal Server Error
HttpSubStatus 19
ErrorCode 2147942526
ConfigExceptionInfo
Notification MAP_REQUEST_HANDLER
ErrorCode The specified module could not be found. (0x8007007e)
ModuleName DynamicCompressionModule
Notification 536870912
HttpStatus 500
HttpReason Internal Server Error
HttpSubStatus 19
ErrorCode 2147942526
ConfigExceptionInfo
Notification SEND_RESPONSE
ErrorCode The specified module could not be found. (0x8007007e)
Any help is greatly appreciated.