PHP cannot update ODBC database.
| From: | Yanchun Zhao | 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/