| Author |
Message |
| genmud |
|
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/board.asp, line 73
1/6/2002 8:29:30 PM |
| Dmitri |
|
This error occurs because ADO is unable to write to the database for one of the following reasons:
- The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.
It is also necessary to give the Internet Guest account Write permissions on the directory containing the .mdb file. This is because Jet creates an .ldb file to handle database locking. You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.
- Another cause of this error is that the database was not opened with the correct MODE for writing. Since the mode never specified it assumes mode 0, which generally allows updates, but I would recommend adding line in Common.asp right before line 11:
10: Set Conn=Server.CreateObject("ADODB.Connection")
new line 11: Conn.Mode = 3 ' 3 = adModeReadWrite
11 became 12: Conn.Open "Driver= ...
- Another cause of this error is that the "Read Only" setting may be checked in the Options page for this DSN in the ODBC Manager.
If problem still exists try to Response.Write and End before line 73 and see if any of the variables are empty or may cause a problem.
Let me know if nothing of the above works.
1/7/2002 10:47:32 AM |
| Andy |
| Re:Re:error message! | REPLY |
|
I had this problem using IIS locally XP. After much clicking I solved the problem by:
Accessing my default Web Site Properties in IIS.
Click the Home Directory Tab
Set the Execute Permissions to Scripts only. (Rather than none, which it was on)
Worth a look…
Now all I have to do is crack the email problem! Good luck!
4/24/2002 7:23:17 PM |
| Dmitri |
| Re:Re:Re:error message! | REPLY |
|
Please, let me know if this is something I can help you with.
Andy wrote on 4/24/2002 7:23:17 PM:
>
> Now all I have to do is crack the email problem! Good luck!
>
4/24/2002 7:57:39 PM |
| Andy |
| Re:Re:Re:Re:error message! | REPLY |
|
Thanks, got the email working. It was an XP thing. No cdonts.dll included with XP IIS! (see email section for my fix)
Dmitri wrote on 4/24/2002 7:57:39 PM:
> Please, let me know if this is something I can help you with.
>
> Andy wrote on 4/24/2002 7:23:17 PM:
> >
> > Now all I have to do is crack the email problem! Good luck!
> >
4/25/2002 10:51:10 AM |
| Dmitri |
| Re:Re:Re:Re:Re:error message! | REPLY |
|
This is interesting. Thank you for sharing.
Andy wrote on 4/25/2002 10:51:10 AM:
> Thanks, got the email working. It was an XP thing. No cdonts.dll in
> cluded with XP IIS! (see email section for my fix)
4/25/2002 11:45:08 PM |
