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

Source: Internet
Author: User
Tags command line iis access database

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.