PHP cannot update ODBC database.

From: Date: Sun, 29 Oct 2000 19:31:52 +0000
Subject: PHP cannot update ODBC database.
Groups: php.general 
Request: Send a blank email to php-general+get-22566@lists.php.net to get a copy of this message
Hi, I used PHP4 on NT with II4 and MS Access database through ODBC. I used odbc_pconnect() and odbc_exec() calls to access database and everything works fine before. But I don't what's wrong recently. All select statements still works fine, but any insert or update statements don't work any more. It gives me the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecute in c:\homepage\test.php on line 18 I upgraded my PHP several time and now used the latest PHP4.03pl1. I don't know when it starts to brake since I have not changed my program for some time and these update sql statements work fine if I run them inside MS Access. Anyone has any ideas? Thanks for help. Yanchun __________________________________________________ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/

« previous php.general (#22566) next »