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.