Does OLE DB provider for MySQL support transactions

Hi,

I am working with MySQL database.

I am using ASP.I am using transaction safe table type InnoDb to create tables in MySQL.

I am accessing these tables from ASP using OLE DB provider for Mysql Version 3.0.When I issue a command like

conn.begintrans

I get the error "Provider does not support Transactions".

Pl. tell me how can I manage transactions for Mysql using the OLE DB provider.I thought of using MyODBC driver,but this driver always gives the recordcount as -1.

-Sachi

i use delphi 6 and ado, but the provider gives me the same message.
I have found Odbc driver that supports transaction, but i don't want to use it.
if you have already resolved your problem, tell me please.

Bye
Thank
mnkt