Kbase P131614: SQL Dataserver - Unable to update identity field.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/20/2008 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Unable to insert record into the table
Unable to insert record when the field with "identity" property is involved
2300: [Microsoft][ODBC SQL Server Driver][SQLServer] Cannot insert explicit value for identity column in table 'customer' when IDENTITY_INSERT is set to off
Database is not migrated using DataServer migration utility
Can not modify the database definitions from SQL server
CAUSE:
The field having "identity" property is being selected for ROWID support
FIX:
Select another index for ROWID support.
At a minimum, an index qualifies to support ROWID if it meets the following criteria:
The index must be defined as unique.
The index must be defined as mandatory, or at least treated as such by your application.
To select a different index, perform following
1. In the dictionary view, select the table, click on data server button
2. In the ROWID selection dialog, select another index that meets following criteria to support ROWID.