#19373 [Opn->Fbk]: conn.execute($sqlstm) failed for add, update and delete in microsoft access 97

ID: 19373 Updated by: phanto@php.net Reported By: jimsonchang@yahoo.com -Status: Open +Status: Feedback Bug Type: COM related Operating System: Windows 2000 PHP Version: 4.2.3 New Comment: pease try a recent version from snaps.php.net Previous Comments: ------------------------------------------------------------------------ [2002-10-02 19:11:31] jimsonchang@yahoo.com no error message, it just won't execute the sql statement for add, update and delete. "select" sql statement is ok. ------------------------------------------------------------------------ [2002-10-02 07:21:46] phanto@php.net do you get any error messages ? ------------------------------------------------------------------------ [2002-09-12 06:54:16] jimsonchang@yahoo.com like summary, conn.execute($sqlstm) failed for adding, updating and deleting sqlstament against microsoft access (ver. 97) i haven't try it in office access 2000. my test ====== i get two computer(A and B), with same php.ini file, using the same php script. comp A is installled with php 4.2.2 while comp B is installed with php 4.2.3 after setup, i run the script, comp A can execute the sql statement i gave without problem... while comp B can only perform sql statement (SELECT * FROM TABLENAME) UPDATE, INSERT INTO and DELETE failed for comp B which is using php 4.2.3 i post the following problem already in the php forum please go there to get the script i test. http://www.phpbuilder.com/board/showthread.php?s=&threadid=10209715 sincerely, Jimson Chang ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19373&edit=1