ID: 35607 Updated by: [EMAIL PROTECTED] Reported By: wseibert at hxcorp dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows 2k PHP Version: 5CVS-2005-12-08 (snap) New Comment:
Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If possible, make the script source available online and provide an URL to it here. Try to avoid embedding huge scripts into the report. Previous Comments: ------------------------------------------------------------------------ [2005-12-08 20:49:06] wseibert at hxcorp dot com Description: ------------ Running a UPDATE sql command via PDO crashes Apache. Reproduce code: --------------- try { $dbh = new PDO('odbc:DSN=TEST;driver=Driver do Microsoft Access (*.mdb)','',''); $results = $dbh->query('UPDATE xd17 SET xd17.CCDate = 20051207, xd17.CCTime = 1200, xd17.ModifiedDS = 200512071200 WHERE xd17.XTyp17 = 157 AND xd17.X15A = 51921 AND xd157.X105B = 3300'); } catch (PDOException $e) { print "Error!: ".$e->getMessage()."<br/>"; die(); } Expected result: ---------------- Expected to see changes in DB. Using exec ($dbh->exec(....) ) instead of query has no effect. Doesn't update the DB or crash anything. SQL statement works find in MS Access. Actual result: -------------- Apache.exe - Application Error The instruction at "0x7c5b97d4" referenced memory at "0x0000000c". The memory could no be "written". ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35607&edit=1