Written before:
It’s all the fault of XP. I personally think that XP pursues security excessively and compensates by not being able to implement specific functions. Let’s take a look at this ASP example. I believe that people who often come into contact with ASP will often encounter this problem. : Obviously my code is written very correctly, why can't it be updated normally? The following error messages are not caused by code errors in ASP itself, but by some permission setting issues. When I first encountered this problem, I once I checked my code no less than 10 times during self-study, but no ASP errors were found. Finally, I checked online and found that it was the evil permissions.
Operating environment: Windows XP
IIS 5.0
------------- -------------------------------------------------- -----
When running an asp program on a Windows XP+IIS server, the database may not be updated. The specific error message may be:
1. Microsoft JET Database Engine (0x80040E09) cannot be updated. The database or object is read-only
2. Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] The operation must use an updateable query.
3. Microsoft JET Database Engine (0x80004005) operation must use an updateable query.
There are several solutions as follows (the solutions may be different for different servers, here we assume that the home directory of the website is wwwroot):
A. Right-click on the wwwroot folder-"Properties"-cancel "Read-only".
This method is the simplest. , Occasionally valid
B. Right-click on the folder in your database file - "Properties" - "Security" - add user: "IUSR_computer name" and open the read and write permissions of "IUSR_computer name"
. This method is currently the best way to solve this problem. It can generally solve the problem.
Under XP system, you may not see the "Security" option when you right-click. Please open "Tools" - "Folder Options" - "View" - Cancel "Use" Simple file sharing (recommended)" Then you can find the "Security" option in the properties
. C. Right-click on the wwwroot folder - "Properties" - "Web Sharing" - "Shared Folder"
D. Please give me more solutions. Discuss with me~QQ:7021357
----------------------------------------- --------------------------
The last point is that if you want to set your machine as a server for debugging ASP, it is best not to use win For XP system, it is better to choose WIN 2000, but if it is not possible... then be prepared to take a lot of detours! ....
Of course, when inexplicable problems occur in XP, please give more thought to the permission settings of XP question