[[SOLVED] php with access]

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

[[SOLVED] php with access]

this site is for help....ok..

[[SOLVED] php with access]

i think there are changing in permission....

[[SOLVED] php with access]

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

?>

[[SOLVED] php with access]

hi dear..

 

in access  it work well..

[[SOLVED] php with access]

any one find solution for that...

[[SOLVED] php with access]

i really need help with that...

[[SOLVED] php with access]

but i want to remember one thing also iam using IIS

[[SOLVED] php with access]

thanks mchl but i didnt get any help with that...

[[SOLVED] php with access]

its about odbc in (php.ini) file:

 

 

 

[ODBC]

;odbc.default_db    =  Not yet implemented

;odbc.default_user  =  Not yet implemented

;odbc.default_pw    =  Not yet implemented

 

; Allow or prevent persistent links.

odbc.allow_persistent = On

 

; Check that a connection is still valid before reuse.

odbc.check_persistent = On

 

; Maximum number of persistent links.  -1 means no limit.

odbc.max_persistent = -1

 

; Maximum number of links (persistent + non-persistent).  -1 means no limit.

odbc.max_links = -1

 

; Handling of LONG fields.  Returns number of bytes to variables.  0 means

; passthru.

odbc.defaultlrl = 4096

 

; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.

; See the documentation on odbc_binmode and odbc_longreadlen for an explanation

; of uodbc.defaultlrl and uodbc.defaultbinmode

odbc.defaultbinmode = 1

 

[[SOLVED] php with access]

i didnt enabled that in php.ini...... what i enable in php.ini... can you tell me please..?

 

 

but with select its ok.. i get the data without any problems

[[SOLVED] php with access]

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

?>

 

 

 

[[SOLVED] php with access]

thanks dear...i will send it.

[[SOLVED] php with access]

i have problem while i send data to access...

i hope i get the answers..thanks for alll

[how to avoid sending data on refresh]

i need help with php search engine..

i want to know if we have a big text and we want to serach for a word in it and contain 4 words in different line or maybe in same line... and i want i get 4 results...

 

thanks for all