loving_php2008 Posted October 31, 2008 Author Share Posted October 31, 2008 i want to insert data from php to microsoft access ,but i got warning.. its the error that i got PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\wwwroot\php\test.php on line 8 . and its the code: <?php $conn=odbc_connect('test','root',''); if($conn) { echo "connect"; } $sql="insert into t1 values(1,'emmy')"; odbc_exec($conn,$sql); ?> Quote Link to comment https://forums.phpfreaks.com/topic/130742-solved-php-with-access/page/2/#findComment-679148 Share on other sites More sharing options...
loving_php2008 Posted October 31, 2008 Author Share Posted October 31, 2008 i think there are changing in permission.... Quote Link to comment https://forums.phpfreaks.com/topic/130742-solved-php-with-access/page/2/#findComment-679207 Share on other sites More sharing options...
DeanWhitehouse Posted October 31, 2008 Share Posted October 31, 2008 That might be the problem, the file may be read only try changing its permission. And please stop bumping this thread. Quote Link to comment https://forums.phpfreaks.com/topic/130742-solved-php-with-access/page/2/#findComment-679227 Share on other sites More sharing options...
loving_php2008 Posted October 31, 2008 Author Share Posted October 31, 2008 this site is for help....ok.. Quote Link to comment https://forums.phpfreaks.com/topic/130742-solved-php-with-access/page/2/#findComment-679240 Share on other sites More sharing options...
DeanWhitehouse Posted October 31, 2008 Share Posted October 31, 2008 Yes, but the help is voluntary so stop bumping ,we are not paid and we do not have to help if someone knows the answer they will post it, bumping just annoys people. Quote Link to comment https://forums.phpfreaks.com/topic/130742-solved-php-with-access/page/2/#findComment-679281 Share on other sites More sharing options...
loving_php2008 Posted November 3, 2008 Author Share Posted November 3, 2008 hi all... PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in C:\Inetpub\wwwroot\php\test.php on line 9 <?php $conn=odbc_connect('test1','',''); if($conn) { echo "connect"; } $sql="insert into t1 values(10,'meme')"; odbc_exec($conn,$sql); ?> in fraction i solved the problem,when i make share of the folder that contain the access database... its work well.... Quote Link to comment https://forums.phpfreaks.com/topic/130742-solved-php-with-access/page/2/#findComment-681361 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.