Discussion Locked

MTS Components

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi all,

I developed VB com component doing update,insert,delete to the
databasee(SQL SERVER 2000) I registered this component under MTS
context.

some times every thing is okay and sometimes the transaction stucked
just halt the mts couldn'tcomplete the transaction or abort it just
half
I checked the database and it is locked.when I kill mtx process
everything goes
well and the transaction is aborted with error.

imagine it like I have to do 3 updates to the database
PENDING,INPROCESS,COMPLETE sometimes the procees stuck in INPROCESS
stage
and never come to complete

so any body have any idea what is going on .

thank you in advance

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.