Microsoft OLE DB Provider for ODBC Drivers error '80004005'


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

  1. #1
    Joe Guest

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'


    This is the error that I get from an update statement that when I run the
    statement in access the statement works fine as so with IIS 4, but when I
    run the statement on IIS 5 I get the error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
    query

    here is the code:
    upd = "update inventory set itemno = '" & request.form("itemno") & "', photo
    = '" & request.form("photo") & _
    "', description = '" & request.form("description") & "', weight = '" &
    request.form("weight") & _
    "', warehouseloc = '" & request.form("location") & "' where ID = " & request.form("ID")



    set rs = conn.execute(upd)
    help!!! thanks in advance Joe

  2. #2
    George Guest

    Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'


    "Joe" <jfrey@pvcomm.com> wrote:
    >
    >This is the error that I get from an update statement that when I run the
    >statement in access the statement works fine as so with IIS 4, but when

    I
    >run the statement on IIS 5 I get the error:
    >
    >Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    >
    >[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
    >query
    >
    >here is the code:
    >upd = "update inventory set itemno = '" & request.form("itemno") & "', photo
    >= '" & request.form("photo") & _
    > "', description = '" & request.form("description") & "', weight = '" &
    >request.form("weight") & _
    > "', warehouseloc = '" & request.form("location") & "' where ID = " & request.form("ID")
    >
    >
    >
    >set rs = conn.execute(upd)
    >help!!! thanks in advance Joe


    Do You Use This Syntax -->

    rst.Open "SELECT * FROM INVENTORY WHERE ID="+request.form("ID"), Conn,3,3

    rst.Update "The Field" , <<new value>>
    rst.Update "The Field" , <<new value>>
    rst.Update "The Field" , <<new value>>
    rst.Save

    rst.close



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center