SQL Error
| From: | zhengu at netzero dot net | Date: | Thu, 20 Jul 2000 19:19:24 +0000 |
| Subject: | SQL Error | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-25277@lists.php.net to get a copy of this message | ||
Hi,
I'm working on a simple form submission app on NT4 and I got it to work. But
when I moved the Access database to a different directory on the same
computer and reconnected the odbc datasource, it stopped working.
i get this error when i submit the form:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query., SQL state S1000 in SQLExecDirect in
d:\medsch\admin\registration\addstudent.php on line 17
the error occurs on
$result = odbc_exec( $conn, $sqlstr );
Both directories have the same permissions and settings. I've tried
rebooting, that didn't help.
please help
thanks
Zhen