Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. Linux, Apache, MySQL, PHP
  4. PHP with ODBC Connectivity

PHP with ODBC Connectivity

Scheduled Pinned Locked Moved Linux, Apache, MySQL, PHP
databasehelpphpquestion
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J Offline
    J Offline
    jayachandra c
    wrote on last edited by
    #1

    Hi All, I am trying to insert the detail into one table with 2 fields. but I am failed to insert. Here I am getting the below error message. Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecute in C:\Inetpub\wwwroot\PHPProgs\StoreData.php on line 9 Whoops below is the code what i have written. Please let me know what is the problem Looking for your valuable reply.

    C W 2 Replies Last reply
    0
    • J jayachandra c

      Hi All, I am trying to insert the detail into one table with 2 fields. but I am failed to insert. Here I am getting the below error message. Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecute in C:\Inetpub\wwwroot\PHPProgs\StoreData.php on line 9 Whoops below is the code what i have written. Please let me know what is the problem Looking for your valuable reply.

      C Offline
      C Offline
      cjoki
      wrote on last edited by
      #2

      Sounds like you may have a permissions issue. Can you insert/update any information to the database or just this table...check your security settings in the db for the user that your script is logging in as.

      1 Reply Last reply
      0
      • J jayachandra c

        Hi All, I am trying to insert the detail into one table with 2 fields. but I am failed to insert. Here I am getting the below error message. Warning: odbc_execute() [function.odbc-execute]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecute in C:\Inetpub\wwwroot\PHPProgs\StoreData.php on line 9 Whoops below is the code what i have written. Please let me know what is the problem Looking for your valuable reply.

        W Offline
        W Offline
        whatrevolution
        wrote on last edited by
        #3

        Yay, googles!!! https://encrypted.google.com/search?q=Operation+must+use+an+updateable+query.,+SQL+state+S1000+in+SQLExecute[^]

        Honestly Illustrated

        <Pretentious> Raid tha manyuhl. :E <Pretentious> Aw raid eh own mah meaxbile. :E

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups