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); ?> 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.... 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. 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.. 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. 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.... 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
Archived
This topic is now archived and is closed to further replies.