Hi:

I would like to understand when you should handle transactions using the
ADO Connection methods for handling transactions and when it is better
to use the MTS for handling transactions?  Are there any rules of thumb
for this?

Thanks,

Sid Connor

MTS is more than just database transactions, it will commit or
abort/rollback all changes done by all objects in a transaction. If all you
need is database transactions on a single connection I would stick to ADO.

--
Regards

Carsten Thomsen
MCSE/VB Programmer & Analyst

PLEASE post ALL replies to the newsgroup(s) so we can all benefit from the
discussion!

You should NEVER use the BeginTrans method of the ADO connection
object.  This locks a whole bunch of stuff on the server until there is
a CommitTrans.  If you have an application that has a large number of
concurrent users, then this is a guaranteed way to have an application
that sucks.

I don't know enought about MTS to comment.  My hunch is that MTS's
benefits are vastly overhyped.

Keep all of your transactions in stored procedures, and then all will
be much better.  The tables in question will be locked for only a
fraction of the time as they would have if you used ADO transactions.

Sent via Deja.com http://www.deja.com/
Before you buy.