Kbase 21583: SQL server DataServer Errors Using SQL Server Identity Column
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
ODBC DataServer
MS SQL DataServer
SYMPTOM(s):
Errors updating a table through data server
** <file-name>.<field-name> is mandatory, but has unknown (?) value. (110)
WARNING: Could not read database record for undoing. (1750)
Tried to access a record without a valid id. (6167)
23000: [Microsoft][SQL Server] Cannot insert explicit value for identity column in table <table> when IDENTIRY_INSERT is set to OFF.
CAUSE:
Your table has an identity column and that column is defined as the ROWID support in the schema holder, your application is trying to insert a value into that column.
The DataServer does not support native fields in SQL Server that are marked with the identity data type (other than through its own implementation of the progress_recid columns).
FIX:
Use the instructions in the DataServer Guide to implement the progress_recid columns or reference Progress Solution:
P63288, How to Modify tables to create PROGRESS_RECID in support of the ROWID function in 4GL?