IIS7.5 prompts that the microsoft.jet.oledb.4.0 provider _win Server is not registered on the local computer

In WIN7 X64 platform IIS7.5, when you use ASP.net to connect to an Access database, you are prompted that the "microsoft.jet.oledb.4.0" provider is not registered on the local computer.

Note: An unhandled exception occurred during the execution of the current WEB request. Check the stack trace for more information about the error and where the error occurred in the code.

Exception Details: System.InvalidOperationException: The "microsoft.jet.oledb.4.0" provider is not registered on the local computer.

SOURCE Error:

An unhandled exception was generated during the execution of the current WEB request. You can use the following exception stack trace to determine information about the cause of the exception and where it occurred.

The reason for the error is probably that microsoft.jet.oledb.4.0 does not support the 64-bit system, so just change the "enable 32-bit application" to true in the advanced settings of the Web site's connection pool, which means that supporting 32-bit applications will solve the problem.

1, open IIS Manager, select the "Application Link Pool" on the left, locate the connection pool name for the debug site, and then right-click "Advanced Settings".

2, in the pop-up "Advanced Settings" dialog box, the "Enable 32-bit application" set to True, and then click OK to resolve.