Jump to content

loving_php2008

Members
  • Posts

    15
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

loving_php2008's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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....
  2. 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); ?>
  3. but i want to remember one thing also iam using IIS
  4. thanks mchl but i didnt get any help with that...
  5. 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
  6. 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
  7. 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); ?>
  8. i have problem while i send data to access... i hope i get the answers..thanks for alll
  9. 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
×
×
  • 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.