RE: PHP cannot update ODBC database.

Ryan, You are right. Thanks a lot. Yanchun --- Ryan Sexton <rsexton@buckeye-express.com> wrote: > Hi Yanchun, > If your database is inside of your website > somewhere, this is usually a > sign that the permissions on the database have been > set to read only. or the > directory is set to read only. change it to allow > writing. i'm 100% sure > that this is the problem, it's happened to me a few > times. > > > Ryan > > > > -----Original Message----- > From: Yanchun Zhao [mailto:yzhao123@yahoo.com] > Sent: None > To: php-general@lists.php.net > Subject: PHP cannot update ODBC database. > > > 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/ > __________________________________________________ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/