Posted by Larry on 06/30/05 20:25

In VB 6, using ADO, SQL Server 2000

In my VB program I use the connection object (abc)
to begin a transaction.

abc.BeginTrans

I then, in my VB App, using ADO, execute multiple stored procedures
inserting records into temp tables ##Meetings,
reading them, and then finnaly executing (from my VB app
using ADO) as stored procedure that inserts records
into a non-temp table.

I then have a abc.CommitTrans

What if my VB program crashes before the
committrans is executed, I assume that the transaction
is rolled back, even though no explicit rollback
is issued, because my VB program has crashed.

Thank You for your help,

Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing Education

[Back to original message]