IDENTITY_INSERT is set to OFF

[Richey]

Hi

I'm using a 3rd party software package and doing an insert with 2 columns (neither are identity columns but just numeric) the identity column is columnID (primary key int(4))

the insert statement is

ExecQuery_X "CONN_Z","00010::insert into tblComplaint_ISB (crmCallID,CustomerID) Values 
(?,?)",array(adNumeric,5,Request("CustID"),adNumeric,5,Request("CustID"))

yet i get the following error message, despite the fact I havn't explicity named the identity column in my insert statement ?

any ideas
thanks

error
-----
Cannot insert explicit value for identity column in table 'tblComplaint_ISB' when IDENTITY_INSERT is set to OFF.

 

[esdee]

could it be the 3rd party software problem?

------------------------

http://esdeeblog.blogspot.com/

 

[Richey]

that is exactly what i am thinking.........
let me guess, they can do it for us at a cost !!