Results 1 to 3 of 3

Thread: Asp Problem Please help

  1. Sep 12th, 2003, 06:47 AM #1
    shilpa_g2
    shilpa_g2 is offline

    Thread Starter
    Member
    Join Date
    Jun 2003
    Posts
    46

    Unhappy Asp Problem Please help

    Hi

    I am having the following error



    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.




    while i try to update my table. I am using Access as backend. code i am using is


    VB Code:
    1. <html>

    2.  
    3. <head>

    4. <title>New Page 2</title>

    5. </head>

    6.  
    7. <body topmargin="0" leftmargin="0">

    8. <!!--#include virtual="/adovbs.inc"-->

    9. <%

    10. Dim objConn

    11. Dim counter ' TO COUNT RETURNED RECORDS

    12. counter = 0

    13. curDir = Server.MapPath("misc/db1.mdb")

    14. set objconn = Server.CreateObject("ADODB.Connection")

    15. set objrs = Server.CreateObject("ADODB.Recordset")

    16.  
    17.  
    18.  
    19. Response.write curDir

    20. objconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & curDir

    21. objrs.cursorLocation = 3

    22. objrs.CursorType = 2

    23. objrs.LockType = 4

    24. ss="update guest set Name='gg' where sno=3"

    25.  
    26.  
    27. objconn.execute ss

    28.  
    29.  

    30.  
    31.  
    32. Response.write curDir

    33. Response.write"<br>"

    34. Response.write objconn

    35. Response.write"<br>"

    36. objConn.Close

    37.  
    38. %>

    39. </body>

    40. </html>










    please help as i have been tring this for last two days is very much upset about this
    Reply With Quote Reply With Quote
  2. Sep 12th, 2003, 08:30 AM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    This might help.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. Sep 16th, 2003, 05:13 AM #3
    dgsatish
    dgsatish is offline
    Member
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    47

    see here

    hello u r using read only lock type..that is why u cannot update...so change the lock tpye and try it.....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width