note 61694 added to function.odbc-exec

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 webnews
accessadd.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
----
Server IP: 217.24.152.9
Probable Submitter: 203.91.142.231
----
Manual Page -- h
ttp://www.php.net/manual/en/function.odbc-exec.php
Edit        -- http://master.php.net/manage/user-notes.php?action=
edit+61694
Delete: added to the manual -- htt
p://master.php.net/manage/user-notes.php?action=delete+61694
&report=yes&reason=added+to+the+manual
Delete: bad code            -- http://master.
php.net/manage/user-notes.php?action=delete+61694&report
=yes&reason=bad+code
Delete: spam                -- http://master.php.
net/manage/user-notes.php?action=delete+61694&report=yes
&reason=spam
Delete: useless             -- http://master.p
hp.net/manage/user-notes.php?action=delete+61694&report=
yes&reason=useless
Delete: non-english         -- http://mast
er.php.net/manage/user-notes.php?action=delete+61694&rep
ort=yes&reason=non-english
Delete: already in docs     -- http://
master.php.net/manage/user-notes.php?action=delete+61694&
;report=yes&reason=already+in+docs
Delete: other reasons       -- http://master.php.net/manage/user-
notes.php?action=delete+61694&report=yes
Reject      -- http://master.php.net/manage/user-
notes.php?action=reject+61694&report=yes
Search      -- http://ma
ster.php.net/manage/user-notes.php

-- 
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

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

-- 
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php