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.
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
solved!
Thanks Kamil!