Ado recorset in Visual Basic with MY SQL data base server

i'm programming an application in Visual Basic using My Sql as DataBase server. In visual basic i'm currently using ADO.
I'm trying to use a transaction to store data in MY SQL using ADO recordsets for "Insert" an "Update" sentences.
When a RollBack action occurs, Visual Basic shows an error that tells that "some non rollback action couldn't be rollback".

Also i'm trying to make one big sentences separated with ";" but in Visual Basic couldn't run.


What can I do to rollback all the sentences.

Thanks in Advance.

MariaFlor