ASP cannot connect to an Access database under 64-bit Windows 2003

Symptom (s): 64-bit Windows 2003 after you have configured IIS, run the ASP page and if there is code connected to an Access database, an error warning appears:

ADODB. Connection error ' 800a0e7a '

Provider not found. The program may not be installed correctly.

/Connect to the site Content Management database. asp, line 2

Reason: IIS runs in 64-bit mode, it can only load 64-bit modules and cannot load 32-bit modules. The jet engine that accesses the Access database has only 32 bits and no 64 bits, so it cannot be loaded by IIS.

Workaround: Let IIS run in 32-bit mode so that it can invoke a 32-bit jet engine

Workaround: Enter in command line window

cscript C:\inetpub\adminscripts\adsutil.vbs SET W3svc/apppools/enable32bitapponwin64 1

The negative effect of the above method: Because IIS is changed to run in 32-bit mode, it can only load 32-bit modules. If IIS loads the other 64-bit modules before it is changed, the module cannot be loaded after the change. If you want to continue using the functionality of this module, you can only look for the 32-bit version of this module and load it.

If you want IIS to run again in 64-bit mode, you can enter

cscript C:\inetpub\adminscripts\adsutil.vbs SET W3svc/apppools/enable32bitapponwin64 0