Hello, on 08/13/2005 09:16 PM Pablo Gosse said the following:
I have the unfortunate task of writing a PHP front-end for a client-server application that is back-ended in MS Access. I've tried using the transaction functionality in ADOdb (PHP implementation of ADO) but it doesn't work seem to work correctly, even though it says it does. If I intentionally submit a malformed query as part of a series of inserts, the ADOdb transaction supposedly rolls back, but when I look at the database, the inserts carried out before the error occurs are still there. Does anyone know if it's possible to use transactions with Access via PHP?
Yes, the Metabase driver for MS Access via ODBC implements transaction support:
http://www.phpclasses.org/metabase -- Regards, Manuel Lemos PHP Classes - Free ready to use OOP components written in PHP http://www.phpclasses.org/ PHP Reviews - Reviews of PHP books and other products http://www.phpclasses.org/reviews/ Metastorage - Data object relational mapping layer generator http://www.meta-language.net/metastorage.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
