When running an ASP program on a windows+iis server, the database may not be updated. The summary is as follows. Friends in need may refer to the following. When running an ASP program on a windows+iis server, the database may not be updated. The specific error message may be:
1. Microsoft JET Database Engine (0x80040E09) cannot be updated. Database or object is read-only
2. Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] operation must use an updateable query.
3. Microsoft JET Database Engine (0x80004005) operation must use an updateable query.
Solution (assume here that the home directory of the website is wwwroot):
Right-click on the wwwroot folder-Properties-Security-Add user: IUSR_computer name and enable read and write permissions for IUSR_computer name
Under XP system, you may not see the security option when you right-click. Please open Tools-Folder Options-View-Cancel Simple File Sharing (recommended) and then find the security option in the properties.
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 their own The 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 checked my own code no less than 10 times during self-study, but no ASP errors were found. Finally, I checked online and found out that it was the evil permissions that were causing the problem. .
Operating environment: windows xp.
IIS 5.0 Copyright Statement: The articles on this site are all from the Internet.
-------------------------------------------------- ------------------.
When running an asp program on a Windows XP IIS server, the database may not be updated. The specific error message may be: Copyright statement: All articles on this site are from the Internet. All reprinted articles on this site do not represent the views of this site.
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] operation must use an updateable query. If you need to use the photography, illustrations, and design works provided on this site, please contact the original author.
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 and occasionally effective. According to expert observations, such theories and phenomena are worth pondering for webmasters, so I hope everyone will do more research and study, and strive to summarize more and better experiences!
B. Right-click on the folder in your database file-Properties-Security-Add user: IUSR_computer name and grant read and write permissions to IUSR_computer name.
This method is currently the best way to solve this problem, and 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 Simple File Sharing (recommended) and then find the security option in the properties. Copyright statement: The articles on this site are all from the Internet. All reprinted articles and comments on this site do not represent the views of this site.
C. Right-click on the wwwroot folder-Properties-web sharing-shared folder.
D. For more solutions, please discuss with me~QQ:7021357.
The last point is that if you want to set up your machine as a server for debugging ASP, it is best not to use win .. Special note: All reprinted articles and comments on this site do not represent the views of this site. If you need to use the photography, illustrations, and design works provided on this site, please contact the original author.
Of course, when inexplicable problems occur in XP, please consider more about XP's permission settings.