I can't seem to commit (in sql server that is)

[thebubbleboy]

I'm currently converting a large and complicated VB app to work with both MySQL and SQL Server (was only MySQL first) so showing code might be a problem.
I have a problem with transactions.
i can begin a transaction using begin tran in recorset.open
and then do a couple of updates again using recordset.open but when i try to commit tran i get an error message saying no corresponding begin to my commit. I have also tried naming them and got the same response.
Anyone got any Ideas?

 

[jebenson]

i can begin a transaction using begin tran in recorset.open

Could you give an example of how you are doing this?

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[thebubbleboy]

the recordset.open command is fine, I've narrowed it down to the @@transcount not being added proprly when accessed from VB, with begins it adds...0,1,0,2,0,3,... and also updates decrement it.
I'm at my wits end