When IIS7 runs asp + access on WN7, an error occurs: ADODB. Connection error.

Error Description: When ASP connects to the Access database, the following error message is displayed: ADODB. Connection error 800a0e7a the provider is not found. The program may not be correctly installed. Conn. asp, line 28 environment: Windowsxp, IIS6.0, Access2007Windows7, IIS7, Access2010 fault solution: Start-run

Error Description: When ASP connects to the Access database, the following error message is displayed: ADODB. Connection error '800a0e7a' no provider is found. The program may not be correctly installed. /Conn. asp, line 28 environment: Windows xp, IIS6.0, Access 2007 Windows 7, IIS7, Access 2010 fault solution: Start-run

Error description:

When ASP is connected to the Access database, the following error message is generated:

ADODB. Connection error '800a0e7a'
No provider found. The program may not be correctly installed.
/Conn. asp, row 28

Environment:
Windows xp, IIS6.0, and Access 2007
Windows 7, IIS7, Access 2010

Troubleshooting:

Start-run-cmd, and enter:

Cscript C: \ inetpub \ adminscripts \ adsutil. vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 true

Press enter to solve the problem.

Note:If the command in CMD prompts that you do not have the permission, Open C: \ Windows \ system32, find cmd.exe, right-click and choose "Run as administrator", and then execute the preceding command.