Transaction Errors

From: Mike Blezien (mickalo_at_frontiernet.net)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 13:44:21 -0600
To: DBI List <dbi-users@perl.org>

Hello,

I keep getting this error when attempting to utilize a database that has Innodb
tables, and using transactions. This is from a Perl/DBI script too:

Error:
Transactions not supported by database at module..... bla..bla

MySQL Version: 4.0.17-standard - Official MySQL-standard binary
and it has innodb enabled, the autocommit is set to 1 on the inital 'connect',
no errors, then when the transaction is executed, the autocommit is set to 0
until the commit is called, of if an error occurs, the rollback is called.

Is there something in the variables I can check to make sure transaction have
been enabled for this particular database ??

Any help or suggestion appreciated :)

TIA 

-- 
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: mickalo@thunder-rain.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Relevant Pages

  • Re: Do Transactions guard against corruption?
    ... when the database is opened and closed. ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Do Transactions guard against corruption?
    ... Have you ever had a database in a 'suspect' state? ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Portents of VMS death
    ... "HP NonStop servers are at the top of the single-system ... databases for each primary database or a single backup for multiple ... no matter how many transactions per second your application ... processing can continue using the backup database with minimal service ...
    (comp.os.vms)
  • Re: Do Transactions guard against corruption?
    ... the last user disconnects. ... Have you ever had a database in a 'suspect' state? ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ...
    (microsoft.public.access.modulesdaovba)
  • Re: Do Transactions guard against corruption?
    ... Have you ever had a database in a 'suspect' state? ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
    (microsoft.public.access.modulesdaovba)