Adodb.connection 800a0e7a Error resolution for IIS7 running ASP in 64-bit Systems _win Server

Today, an ASP site copy to the 64-bit Windows7, IIS7 installation is no problem, but is not run, always appear adodb.connection error "800a0e7a", really strange, before running a little problem in XP. Originally thought is the reason of the code, so write a paragraph of the simplest Connection database code, or error, research half day finally found a solution, take to share.

The reason is that the IIS7 application pool does not have 32-bit applications enabled by default in a 64-bit Windows7 operating system. And we connect the Access database driver microsoft.jet.oledb.4.0 is 32-bit, so there is an error, in order to run properly, you only need to enable 32-bit applications. The method is as follows:

1. Open the IIS Information Service Manager and click the "View Application Pool" link in the rightmost window
2. Click the "Set Application pool Defaults" link in the window that appears and set the "Enable 32-bit application in general" setting to "True" in the pop-up window

It can be inferred from the above that if there are other errors, it may be due to the 32-bit program running in 64 of the program pool caused by, such as the ISAPI DLL, if it is 32, but also to modify the above line, the attached picture: