NOTE: you MUST call this immediately after connecting to the server and selecting a database i.e before issuing any queries. If you do not, it appears that for the duration of your script, auto-commit is set to its default, true value. You will be unable to rollback transactions.
David Gillies
San Jose
Costa Rica