Kbase P126720: Getting ODBC error identity_insert is set to off when creating record on MS SQL Server 2005 database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/23/2009 |
|
Status: Verified
SYMPTOM(s):
Getting ODBC error identity_insert is set to off when creating record on MS SQL Server 2005 database
23000: [Microsoft][SQL Native Client][SQL Server]Cannot insert explicit value for identity column in when IDENTITY_INSERT is set to OFF
FACT(s) (Environment):
Records on the table can be inserted using SQL Server query analyzer tool in SQL Server
Both SQL server and native drivers show the above error
Added a new table using the delta.sql utility
The only identity field is being used is PROGRESS_RECID_IDENT_
The .sql file created by delta.sql utility is run using SQL Server query analyzer tool in SQL Server
The .df file generated by delta.sql utility is applied to schema holder
MS SQL DataServer
OpenEdge 10.1x
CHANGE:
A new table is added to the database
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
To workaround the error follow the steps below:
1. Create a new empty progress database
2. Connect to it in a single user mode
3. Using the DataServer > MS SQL Server Utilities > Create DataServer Schema..., create a new schema holder by pulling all the tables from SQL Server database
4. While connected to the schema holder, connect to the source progress Database where the new progress table is added
5. On the Data Administration > Database > Select Working Database, select the Database Type MSS
6. Using the DataServer > MS SQL Server Utilities > Schema Migration Tools > Adjust Schema..., adjust the schema holder to reflect all progress related attributes as well as triggers.