Commit Trans

[JLR1234]

I can't figure this out.

I have a VB6 application writing to an SQL Server 2005 database. At one point in the application, I delete an invoice. This function touches multiple tables using select, update and delete commands. The code is surrounded by BeginTrans and CommitTrans. I don't receive ANY error messages when stepping through the code. After the function completes, the changes have not been made. It's as if the transactions are not committed.

If I remove the begintrans and committrans lines, the transactions do actually occur in the database properly.

Here's the crazy thing... this EXACT code works properly when writing to an SQL Server 2000 database instead of 2005.

Any thoughts?

 

[JLR1234]

I tested another database and the code doesn't work on an SQL Server 2000 database either. So, I still don't understand why the transactions won't commit...

 

[JLR1234]

I found the problem. When I ran the code through SQL Server directly, I received an error message on a select statement. VB did not throw an error when it was run through VB.