Professional Web Applications Themes

ADODB.Field error '800a0cb3' - ASP Database

I tried to modify the field in my ASP page, and it yields the following error: I tried to use adLockOptimistic as follows, but still not working objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic ADODB.Field error '800a0cb3' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. any ideas? thanks...

  1. #1

    Default ADODB.Field error '800a0cb3'

    I tried to modify the field in my ASP page, and it yields the following
    error:

    I tried to use adLockOptimistic as follows, but still not working
    objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic
    ADODB.Field error '800a0cb3'

    Current Recordset does not support updating. This may be a limitation of the
    provider, or of the selected locktype.

    any ideas? thanks


    Matthew Louden Guest

  2. #2

    Default ADODB.Field error '800a0cb3'

    I tried to modify the field in my ASP page, and it yields the following
    error:

    I tried to use adLockOptimistic as follows, but still not working
    objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic
    ADODB.Field error '800a0cb3'

    Current Recordset does not support updating. This may be a limitation of the
    provider, or of the selected locktype.

    any ideas? thanks


    Matthew Louden Guest

  3. #3

    Default Re: ADODB.Field error '800a0cb3'

    Matthew Louden wrote:
    > I tried to modify the field in my ASP page, and it yields the
    > following error:
    >
    > I tried to use adLockOptimistic as follows, but still not working
    > objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic
    > ADODB.Field error '800a0cb3'
    >
    > Current Recordset does not support updating. This may be a limitation
    > of the provider, or of the selected locktype.
    >
    > any ideas? thanks
    We'll need a little more information than that:

    Database type and version

    The code you used to generate the error.

    If it's an Access database, this may be relevant:
    [url]http://www.aspfaq.com/show.asp?id=2062[/url]

    But the error message is puzzling.

    You should not be using a recordset to modify your data. You should be using
    SQL DML statements (UPDATE, INSERT and DELETE), preferably encapsulated in
    stored procedures or saved parameter queries. see these links to see how
    easy it is:
    [url]http://tinyurl.com/qg4o[/url]
    [url]http://tinyurl.com/qg3u[/url]
    [url]http://tinyurl.com/qg47[/url]
    [url]http://tinyurl.com/qg4j[/url]

    HTH,
    Bob Barrows


    Bob Barrows Guest

  4. #4

    Default Re: ADODB.Field error '800a0cb3'

    Matthew Louden wrote:
    > I tried to modify the field in my ASP page, and it yields the
    > following error:
    >
    > I tried to use adLockOptimistic as follows, but still not working
    > objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic
    > ADODB.Field error '800a0cb3'
    >
    > Current Recordset does not support updating. This may be a limitation
    > of the provider, or of the selected locktype.
    >
    > any ideas? thanks
    We'll need a little more information than that:

    Database type and version

    The code you used to generate the error.

    If it's an Access database, this may be relevant:
    [url]http://www.aspfaq.com/show.asp?id=2062[/url]

    But the error message is puzzling.

    You should not be using a recordset to modify your data. You should be using
    SQL DML statements (UPDATE, INSERT and DELETE), preferably encapsulated in
    stored procedures or saved parameter queries. see these links to see how
    easy it is:
    [url]http://tinyurl.com/qg4o[/url]
    [url]http://tinyurl.com/qg3u[/url]
    [url]http://tinyurl.com/qg47[/url]
    [url]http://tinyurl.com/qg4j[/url]

    HTH,
    Bob Barrows


    Bob Barrows Guest

Similar Threads

  1. ADODB.Command error '800a0cc1'
    By Rod in forum ASP Database
    Replies: 3
    Last Post: January 29th, 02:29 PM
  2. ADODB.Connection error '800a0046'
    By Michael Ralph in forum ASP Database
    Replies: 15
    Last Post: October 2nd, 07:39 PM
  3. #25481 [Opn->Bgs]: ADOdb -> fields error
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: September 11th, 12:29 AM
  4. Replies: 1
    Last Post: September 10th, 05:43 PM
  5. ADODB.Field error '80020009
    By olivier Micheli in forum ASP
    Replies: 0
    Last Post: August 15th, 07:43 AM

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