Transaction not commited rolled back?

30 Jun 2005 5:07 PM

Larry

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

30 Jun 2005 5:19 PM

John Bell

Hi

Look up the topic "Controlling Transactions" in Books online. The
transaction will rollback once SQL server is notified that the connection has
been broken.

John

Show quote

"Larry" wrote:

> 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
>