26.1.14.3. What Causes Transactions are not enabled Errors?
The driver returns this error when an application issues any
transactional call but the underlying MySQL server either does
not support transactions or they are not enabled.
To avoid this problem, you must use a server that has either or
both of the InnoDB or BDB
storage engines enabled, and use tables of those types. MySQL
servers from version 4.0 and up support
InnoDB by default. MySQL-Max servers also
support BDB on platforms where
BDB is available.
Also, if your server supports transactional storage engines
(InnoDB and BDB) make sure
the disable transactions option is not set
from the DSN configuration.