Home » U++ Library support » U++ SQL » MSSQL new strange story :)
MSSQL new strange story :) [message #19490] |
Mon, 08 December 2008 11:18 |
|
mirek
Messages: 13975 Registered: November 2005
|
Ultimate Member |
|
|
SQL* SET IDENTITY_INSERT ORG ON
SQL* insert into ORG(ID, PARENT_ID, ORDERBY, NAME, KIND) values (0, NULL, 0, 'Company', 0)
ERROR Execute(OleDB): 23000(544): Cannot insert explicit value for identity column in table 'ORG' when IDENTITY_INSERT is set to OFF. (Microsoft SQL Server Native Client 10.0)(0): insert into ORG(ID, PARENT_ID, ORDERBY, NAME, KIND) values (0, NULL, 0, 'Company', 0)
## ERROR: Execute(OleDB): 23000(544): Cannot insert explicit value for identity column in table 'ORG' when IDENTITY_INSERT is set to OFF. (Microsoft SQL Server Native Client 10.0)
SQL* insert into ORG(ID, PARENT_ID, ORDERBY, NAME, KIND) values (1, NULL, 1, 'Company', 1)
ERROR Execute(OleDB): 23000(544): Cannot insert explicit value for identity column in table 'ORG' when IDENTITY_INSERT is set to OFF. (Microsoft SQL Server Native Client 10.0)(0): insert into ORG(ID, PARENT_ID, ORDERBY, NAME, KIND) values (1, NULL, 1, 'Company', 1)
## ERROR: Execute(OleDB): 23000(544): Cannot insert explicit value for identity column in table 'ORG' when IDENTITY_INSERT is set to OFF. (Microsoft SQL Server Native Client 10.0)
SQL* SET IDENTITY_INSERT ORG OFF
Hard to say what to think...
Maybe I should get balls and sink myself deeply into those strange OleDB interfaces?
Mirek
|
|
|
|
Goto Forum:
Current Time: Mon Apr 29 04:52:22 CEST 2024
Total time taken to generate the page: 0.03662 seconds
|