Identity_Insert Error in SQL Server DB???

kishi_g
kishi_g Member Posts: 162
edited 2009-12-02 in NAV/Navision Classic Client
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.

Comments

  • kine
    kine Member Posts: 12,562
    It seems that you are using the Autoincrement somehow... CHeck this property on the fields in the table.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ta5
    ta5 Member Posts: 1,164
    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
    kine Member Posts: 12,562
    Just read again my post... "Autoincrement"... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ta5
    ta5 Member Posts: 1,164
    yes, autoincrement ](*,)
    solved!

    Thanks Kamil!

Categories