Kbase P1237: Read Only Settting causes Error: Operation Must Use an Updateable Query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Active Server Pages are being used to modify the data in the database.
The Internet Guest Account (IUSR_MACHINE) has write permissions.
The database is opened with the correct MODE for writing.
SQL statements do not violate referential integrity of the database.
Error: Operation Must Use an Updateable Query.
CAUSE:
Typically, the error occurs when your script attempts to perform an UPDATE or some other action that alters the information in the database. It appears because ADO is unable to write to the database because the "Read Only" setting is checked off in the Options page for this DSN in the ODBC Manager.
FIX:
Deselect the "Read Only" setting.