MTS Packages and Stored Procedures

[CShellVB]

Having problems updating SQL Server table that has 2 unqiue indexes in it through a MTS call. One Index is an IDENTITY field called "ID" and the other a SerialNumber field which is Text(20). My component calls a stored procedure in SQL Server (7.0) and returns an error:


Error Number = -2147217873
Error Description = Cannot insert duplicate key row in object 'SerialNumbers' with unique index 'IX_SerialNumbers'.

SerialNumbers is the table obviously, the record gets added to the table even though the error occured (???). The ID number is incremented by 2 instead of 1..? This indicates that the first one failed and the second succeeded. There is some speculation that this is caused by conflicting transactions between SQL Server and MTS..? Has anyone had experience with this issue.

 

[baza]

i am having a problem very similar to yours. my is the same error num and err description.
mine is not inserting anything but coming back with these errors.
when i looked up on the microsoft knowledege base it says that "A specified value violated the integrity constraints for a column or table."
I have check everything in the table the stored procedure and the variables I am sending but still cannot find the error,

have you sorted yours out yet. if so could you tell me how

Many thanx

baza