ERROR in inserting data into table

[nikki]

When i try to insert data into a table it is getting this error.Same exe is working fine in other branches.only in one branch it is raising this error. can u tell me why this error comes and how to overcome this problem?
ERROR Is:
[Microsoft][ODBC SQL server driver][SQL server].An explicit value for the identity column in table 'dayendsalesdetails' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Thanks

 

[TechGnome]

Simply put... you have a field in your table that is marked as an IDENTITY field. Your insert statement is trying to insert a value into that field. This is not allowed. At least not directly.

Look at your insert SQL and see what it looks like and make sure you are not trying to insert a value into that field.

-tg

 

[nikki]

Thanks very much