MySQL and COM+ Transaction Issue

Hi all,

I am using a single COM+ classes that do multiple database operations, eg. insert, update and delete on MySQL server with ODBC connection. I have set the transaction attribute to REQUIRED

eg.

1. update() ... success
2. delete() ... success
3. update() ... fail

If 3. fail, then operation 1. and 2. should rollback. However,
1. and 2. have been commited.

My question is, can MySQL support transactional management?
Is there any specific driver I need to use in order to support
transaction management?

Thanks in advance.

Best Regards,
carl cs.

You need to make use of the InnoDB engine. Here is the definitive reference guide:

http://www.innodb.com/ibman.html

hi torrent,

Good day! Thanks for your replied. :-)

Just would like to ask you if you have try to use InnoDB/MySQL with COM+ object successfully? Is the transactional controllable?

Regards,
cs.

I haven't used it with the COM+ as I use Unix servers. Sounds like an interesting idea though. Do you have a list of InnoDB's object methods?