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

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