Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.8.6

Bug #13387 mssql - BEGIN TRANSACTION not include
Submitted: 2008-03-13 13:09 UTC
From: georgbez Assigned: ifeghali
Status: No Feedback Package: MDB2_Schema
PHP Version: 5.2.5 OS: Windows 2000
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 10 - 1 = ?

 
 [2008-03-13 13:09 UTC] georgbez (Georg Bez)
Description: ------------ After I mentioned in the file example4/demodata.xml (for demodata.php) line from 1647 following the change made <field> <name>news</name> <type>clob</type> </field> Now it works with my local mysql database without problems. Only if I try mssql comes with the following error message I could not populate the database, see error below MDB2_Schema Error: unknown error Could not end transaction (MDB2 Error: unknown error (_doQuery: [Error message: Could not execute statement] [Last executed query: COMMIT TRANSACTION] [Native code: 3902] [Native message: Die COMMIT TRANSACTION-Anforderung hat keine entsprechende BEGIN TRANSACTION.] ))

Comments

 [2008-03-24 00:03 UTC] ifeghali (Igor Feghali)
no clue what the error message means. maybe MSSQL doesnt support transactions and the driver tells the oposite ?
 [2008-03-26 20:14 UTC] quipo (Lorenzo Alberton)
The error message says: The COMMIT TRANSACTION query has no corresponding BEGIN TRANSACTION. SQL Server does support transactions. Can you send me the query log?
 [2008-10-25 00:58 UTC] ifeghali (Igor Feghali)
please pass the following array to MDB2_Schema factory: $options = array( 'disable_query' => false, 'debug' => 'false', 'debug_handler' => 'printQueries', 'parser' => 'MDB2_Schema_Parser', 'quote_identifier' => true, 'log_line_break' => '<br>', 'use_transactions' => false ); that should disable transactions. please tell me if that fix your problem.