i have installed innodb and created some tables. i can do transactions with mysql. but cannot do transactions from Visual Basic using ADO and the OLEDB provider for mysql. the error mesage is "the provider does not support transactions". How can i solve this. does the OLEDB provider for MySQL support transaction. if i Use the ODBC the transaction is allowing, even on a myISAM type table. what is all this happening.
pls help. is there a sample availabe for VB to Use mysql.

thanks in advance