Jump to content

Archived

This topic is now archived and is closed to further replies.

loving_php2008

[SOLVED] php with access

Recommended Posts

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);

?>

Share this post


Link to post
Share on other sites

That might be the problem, the file may be read only try changing its permission. And please stop bumping this thread.

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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....

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.