My SQL data base server with ADO recorsets from Visual Basic

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

Hi Mariaflor!
Look, for what I know, MySQL started to support transactions in the newest versions only. And your tables must be the type of InnoDB or BDB.
If you can't change your tables type, you should also consider using the command:

LOCK TABLES table_name READ, table_name2 WRITE;

And after finishing the SQLs... use:

UNLOCK TABLES;

By the way, to change to those kind of table types, I think that is only at the creation of the table.
You can get a software called MySQLFront, it's freeware and I think that with it you can do it.