Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help on Creating an MTS(COM+) Transaction loop
Thankyou SemperFiDownUnda :), I was aware that if it worked it would have to persist each connection (even a 1000) until the setcomplete (In practice it would be limited to on avg about 10). I can think of better ways of doing this but not without rewriting a lot of code (3 months). What I...- DJWL
- Post #3
- Forum: Microsoft: COM+
-
Help on Creating an MTS(COM+) Transaction loop
Hi, everyone I have a multiple insert procedure something like below. The data layer methods each create a connection, run a stored procedure(SQL Server) and close the connection. Can anybody tell me if this will work and roll back when/if an error is found. I am worried that running the same...- DJWL
- Thread
- Replies: 3
- Forum: Microsoft: COM+
