note 61694 rejected from function.odbc-exec by nlopess
| From: | nlopess@php.net | Date: | Thu, 09 Feb 2006 20:37:56 +0000 |
| Subject: | note 61694 rejected from function.odbc-exec by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-103384@lists.php.net to get a copy of this message | ||
Note Submitter: hoseinquest at gmail dot com
----
hi
i have an odbc connection to an Access database file
when i try to insert data into the database , i see this error message:
--------------
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.,
SQL state S1000 in SQLExecDirect in F:\my web\news access\add.php on line 23
------------
the source:
$db = odbc_connect("news","","") or die("cannot connect");
$query = "insert into news
values('','sa','a','')";
odbc_exec($db,$query);
------------------
or:
$db = odbc_connect("news","","",2) or die("cannot
connect");
$query = "insert into news
values('','sa','a','')";
odbc_exec($db,$query);
-------------------
also i test it with odbc_prepare and other functions but it not works
please help me for god faster
thanks please call me with email