Professional Web Applications Themes

Operation must use an updateable query Error - ASP Database

Group, On a W2K3 / IIS 6.0 Server, we have a Web Site reading an .mdb fine. When it tries to save, it generates the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /web/version_1.9/admin/updateinfo.asp, line 24 I've search high and low in TechNet. I did implement this item with no help. [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url] us;830977 Code: <%LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% dim Message,ttl Message = request.form("bodytxt") Message = Replace(Message,"""","""",1,-1,vbTextCompare) Message = Replace(Message,"'","''",1,-1,vbTextCompare) ttl = request.form("hometitle") ttl = Replace(ttl,"""","""",1,-1,vbTextCompare) ttl = Replace(ttl,"'","''",1,-1,vbTextCompare) ' Connect to database set objconn=Server.CreateObject ("ADODB.Connection") 'response.write objconn.mode 'objconn.mode ...

  1. #1

    Default Operation must use an updateable query Error

    Group,

    On a W2K3 / IIS 6.0 Server, we have a Web Site reading
    an .mdb fine. When it tries to save, it generates the
    following error:

    Microsoft OLE DB Provider for ODBC Drivers
    error '80004005'

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

    /web/version_1.9/admin/updateinfo.asp, line 24

    I've search high and low in TechNet.
    I did implement this item with no help.

    [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
    us;830977

    Code:
    <%LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
    <%
    dim Message,ttl
    Message = request.form("bodytxt")
    Message = Replace(Message,"""","""",1,-1,vbTextCompare)
    Message = Replace(Message,"'","''",1,-1,vbTextCompare)
    ttl = request.form("hometitle")
    ttl = Replace(ttl,"""","""",1,-1,vbTextCompare)
    ttl = Replace(ttl,"'","''",1,-1,vbTextCompare)

    ' Connect to database

    set objconn=Server.CreateObject ("ADODB.Connection")
    'response.write objconn.mode
    'objconn.mode = 3

    objconn.open "Driver={Microsoft Access Driver (*.mdb)};
    DBQ="& Server.MapPath ("ihldb\ihldb.mdb")
    'objconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
    Source="& Server.MapPath ("ihldb\ihldb.mdb")

    ' Update Database

    sqlstr="UPDATE home SET hometitle='"&ttl&"',
    homedesc='"&Message&"',homeimg='noimg' WHERE
    homeid="&request.form("infoid")
    'response.write sqlstr
    Set objrs=objconn.Execute(sqlstr)

    response.redirect("admin_index.asp")

    %>
    Ray P. Guest

  2. #2

    Default Re: Operation must use an updateable query Error

    Ray P. wrote:
    > Group,
    >
    > On a W2K3 / IIS 6.0 Server, we have a Web Site reading
    > an .mdb fine. When it tries to save, it generates the
    > following error:
    >
    > Microsoft OLE DB Provider for ODBC Drivers
    > error '80004005'
    >
    This is not the cause of this particular problem, but you should stop using
    the obsolete ODBC drivers, using the native Jet OLEDB provider instead. See
    here: [url]www.able-consulting.com/ado_conn.htm[/url]
    > [Microsoft][ODBC Microsoft Access Driver] Operation must
    > use an updateable query.
    Your answer will very likely be found in one of these articles:
    [url]http://www.aspfaq.com/show.asp?id=2062[/url] - updatable cursor
    [url]http://www.aspfaq.com/show.asp?id=2009[/url] - 80004005 errors

    Bob Barrows

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Barrows Guest

  3. #3

    Default Re: Operation must use an updateable query Error

    Permissions are set incorrect at the server level.

    "Ray P." <raypaganini.com> wrote in message
    news:0e8401c3b683$51766330$7d02280aphx.gbl...
    > Group,
    >
    > On a W2K3 / IIS 6.0 Server, we have a Web Site reading
    > an .mdb fine. When it tries to save, it generates the
    > following error:
    >
    > Microsoft OLE DB Provider for ODBC Drivers
    > error '80004005'
    >
    > [Microsoft][ODBC Microsoft Access Driver] Operation must
    > use an updateable query.
    >
    > /web/version_1.9/admin/updateinfo.asp, line 24
    >
    > I've search high and low in TechNet.
    > I did implement this item with no help.
    >
    > [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
    > us;830977
    >
    > Code:
    > <%LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
    > <%
    > dim Message,ttl
    > Message = request.form("bodytxt")
    > Message = Replace(Message,"""","""",1,-1,vbTextCompare)
    > Message = Replace(Message,"'","''",1,-1,vbTextCompare)
    > ttl = request.form("hometitle")
    > ttl = Replace(ttl,"""","""",1,-1,vbTextCompare)
    > ttl = Replace(ttl,"'","''",1,-1,vbTextCompare)
    >
    > ' Connect to database
    >
    > set objconn=Server.CreateObject ("ADODB.Connection")
    > 'response.write objconn.mode
    > 'objconn.mode = 3
    >
    > objconn.open "Driver={Microsoft Access Driver (*.mdb)};
    > DBQ="& Server.MapPath ("ihldb\ihldb.mdb")
    > 'objconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
    > Source="& Server.MapPath ("ihldb\ihldb.mdb")
    >
    > ' Update Database
    >
    > sqlstr="UPDATE home SET hometitle='"&ttl&"',
    > homedesc='"&Message&"',homeimg='noimg' WHERE
    > homeid="&request.form("infoid")
    > 'response.write sqlstr
    > Set objrs=objconn.Execute(sqlstr)
    >
    > response.redirect("admin_index.asp")
    >
    > %>

    GVaught Guest

Similar Threads

  1. "Operation must use an updateable query".- after conversion to NTFS
    By Aaron [SQL Server MVP] in forum ASP Database
    Replies: 6
    Last Post: August 11th, 10:53 AM
  2. operation must use updateable query
    By Tomas in forum ASP Database
    Replies: 3
    Last Post: June 4th, 05:08 AM
  3. Operation must use an updateable query.
    By Frustrated in forum ASP Database
    Replies: 16
    Last Post: April 13th, 06:25 PM
  4. INSERT error :: Updateable query?
    By jason in forum ASP
    Replies: 6
    Last Post: August 9th, 08:06 PM
  5. Replies: 2
    Last Post: July 29th, 07:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139