Identity_Insert Error in SQL Server DB???

kishi_g

Hi,
we r using SQL Server with Two Navision Databases. Now i want to transfer the data from One DB to another DB. I Configure DSN and i created one report. when i run the report i got error:

The Call to member Execute falied. Microsoft OLE DB Provider for ODBC Drivers returned the following message:[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot insert explicit value for identity column in table 'Company Name$Temp_Item' when IDENTITY_INSERT is set to OFF


how can i resolve this error????



Thanks & Regards,
kishore.

kine

It seems that you are using the Autoincrement somehow... CHeck this property on the fields in the table.

ta5

Hi
We have excactly the same problem.
The field in question is marked as "Identity Column" in the sql server table designer.
The question for me: In what cases is a colum marked as "Identity Column", when the table is created from within NAV?

Thanks in advance
Thomas

kine

Just read again my post... "Autoincrement"... ;-)

ta5

yes, autoincrement ](*,)
solved!

Thanks Kamil!