Windows2008 64-bit Iis7+access database cannot open ASP page

Source: Internet
Author: User
Tags iis mdb database access database

1. Let IIS7 support ASP

IIS7 in Windows Vista is not installed by default, so if you need to install IIS7 after you install Windows Vista, you'll have to do it yourself. The steps to install are: Start Control Panel program turn on or turn off Windows features Internet Information Services ("Windows components" in the previous operating system version is called "Programs and Features" in Vista). IIS7 installation needs to be aware of, if you need ASP, ASP. NET, and so on, is required to install the function module, the default is not installed.

  2. Resolve the IIS7. mdb database problem.

After IIS7 is installed by default, the ASP program discovers that the prompt database connection failed, and looked for it on the Internet because the MS Jet engine changed the location of the temp directory, but did not have temporary access rights, resulting in database usage failure.

Add a user for "Authenticated users" to the "system disk: Windowsserviceprofilesnetworkserviceappdatalocaltemp" directory where the AppData directory is hidden, You can enter the path directly in the address bar when entering, or display hidden files in Folder options.

To set permissions step: Right-click the Temp folder and choose Properties Select the Security tab Click Edit to come out the Temp Permissions dialog box, click Add, and then enter authenticated Users in the Enter object name to select, OK returns to Temp's Permissions ", will be authenticated users of the full control on the hook, ok" OK.

Link way:

Serverpath=server.mappath ("/xxx.mdb")

Connstr= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Serverpath

Set schooldb=server.createobject ("Adodb.connection")

Schooldb. Open ConnStr

  3. Windows 2008 64-bit system solves the problem of the. mdb database in IIS7.

If you use a 64-bit system, it may not work as well because the 64-bit system does not provide a 64-bit access connection driver, and the "Enable 32-bit application" for projects in the corresponding application pool of the Web site is "ture". That's it.

Other tips in IIS7:

A. Enable the parent path.

Commonly used in ... /parent path used in IIS7 is not supported by default.

On the home page of IIS-->asp-> double hit Open-> enable parent path: True

B. Return an error message to the browser.

Default page code error browser will appear "An error occurred on the" processing the URL. Please contact the system administrator.

On the homepage of IIS-->asp-> double hit open-> debug error-> send error to browser: True

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.