64-bit system iis7asp + access Connection Error

Source: Internet
Author: User
Tags mdb database
1. Solve iis7. after IIS7 is installed on the mdb database by default, the ASP program will find a prompt indicating that the database connection failed. I found it online, saying that the MSJet engine has changed the location of the temporary directory, however, the database fails to use because it does not have temporary access permissions. To the System Disk: WindowsServiceProfilesNetworkService

1. Solve iis7. after IIS7 is installed on the mdb database by default, the ASP program will find a prompt indicating that the database connection failed. I found it online, saying that it was because the MS Jet Engine changed the location of the temporary directory, however, the database fails to use because it does not have temporary access permissions. To the System Disk: \ Windows \ ServiceProfiles \ NetworkService \

1. Solve the. mdb database problem in iis7

After IIS7 is installed by default, the database prompt is displayed when ASP is used.ConnectionFailed. I found it online, because the MS Jet Engine has changed the location of the temporary directory, but does not have temporary access permissions, resulting in database usage failure.

ToSystemDisk: \ Windows \ ServiceProfiles \ NetworkService \ AppData \ Local \ Temp "directory to add an" Authenticated Users "user, where the AppData directory is hidden, you can enter a path in the address bar or hide the file in the folder option.

To set permissions, right-click the Temp folder, select Properties, select Security tab, click Edit, and then click Add ", in the following "input object name to select", enter Authenticated Users, OK, and return to "Temp permission". The Authenticated Users permission is fully controlled and checked.

Link Method:

ServerPath = Server. MapPath ("/xxx. mdb ")

Connstr = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source =" & ServerPath

Set schooldb = Server. CreateObject ("Adodb. Connection ")

Schooldb. Open connstr

2. windows 2008 64-bitSystemSolve the. mdb database problem in IIS7

If you use 64-bitSystem, The above method may not be able to solve, because the 64-bitSystemNo 64-bit access is providedConnectionThe "enable 32-bit application" of the project in the application pool corresponding to the website is set to "true ". In this way, you can.

A. Enable parent path

Common ../parent paths are not supported by default in IIS7.

On the iis homepage, choose ASP> double-click to enable parent path: True.

Reprinted from 64-bitSystemIis7 asp + accessConnectionError| Exabytes

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.