ADODB.Connection error '800a0e7c'

Discussion in 'ASP .Net' started by PJ, Oct 29, 2003.

  1. PJ

    PJ Guest

    I'm getting an error message when posting information from my asp page
    to the database. This is the error message:
    DODB.Connection error '800a0e7c'

    Parameter object is improperly defined. Inconsistent or incomplete
    information was provided.

    /taxapp/installments.asp, line 207

    this is the code I'm using to post to database:

    <%

    set oConn=Server.CreateObject("ADODB.Connection")
    oConn.open Application("../fpdb/database.mdb")
    dim oRS
    set oRS=server.CreateObject("ADODB.recordset")
    oRS.Open "results", oConn, adOpenForawardOnly, adLockReadOnly,
    adCmdTable
    oRS.UpdateBatch
    oRS("owner")=request.form("owner")
    oRS("full")=request.form("full")
    oRS("address1")=request.form("address1")
    oRS("address2")=request.form("address2")
    oRS("address3")=request.form("address3")
    oRS("address4")=request.form("address4")
    oRS("city")=request.form("city")
    oRS("state")=request.form("state")
    oRS("zip")=request.form("zip")
    oRS("number")=request.form("number")
    oRS("pmid")=request.form("pmid")
    oRS("app_code")=request.form("app_code")
    oRS("description")=request.form("description")
    oRS("Email1")=request.form("Email1")
    oRS("Email2")=request.form("Email2")
    oRS("area_code")=request.form("area_code")
    oRS("phone1")=request.form("phone1")
    oRS("phone2")=request.form("phone2")
    oRS("confnum")=request.form("confnum")
    oRS.update
    oRS.close
    set oRS=Nothing
    %>
    What am I missing,,,,I'm going nuts. Easy to tell I'm a little new at
    this stuff. Any help would be helpful Thank you
    PJ, Oct 29, 2003
    #1
    1. Advertising

  2. 1. Show us connection string. The one you keep in
    Application("../fpdb/database.mdb")
    2. Use SQL to update it's going to improve performance.

    George.



    "PJ" <> wrote in message
    news:...
    > I'm getting an error message when posting information from my asp page
    > to the database. This is the error message:
    > DODB.Connection error '800a0e7c'
    >
    > Parameter object is improperly defined. Inconsistent or incomplete
    > information was provided.
    >
    > /taxapp/installments.asp, line 207
    >
    > this is the code I'm using to post to database:
    >
    > <%
    >
    > set oConn=Server.CreateObject("ADODB.Connection")
    > oConn.open Application("../fpdb/database.mdb")
    > dim oRS
    > set oRS=server.CreateObject("ADODB.recordset")
    > oRS.Open "results", oConn, adOpenForawardOnly, adLockReadOnly,
    > adCmdTable
    > oRS.UpdateBatch
    > oRS("owner")=request.form("owner")
    > oRS("full")=request.form("full")
    > oRS("address1")=request.form("address1")
    > oRS("address2")=request.form("address2")
    > oRS("address3")=request.form("address3")
    > oRS("address4")=request.form("address4")
    > oRS("city")=request.form("city")
    > oRS("state")=request.form("state")
    > oRS("zip")=request.form("zip")
    > oRS("number")=request.form("number")
    > oRS("pmid")=request.form("pmid")
    > oRS("app_code")=request.form("app_code")
    > oRS("description")=request.form("description")
    > oRS("Email1")=request.form("Email1")
    > oRS("Email2")=request.form("Email2")
    > oRS("area_code")=request.form("area_code")
    > oRS("phone1")=request.form("phone1")
    > oRS("phone2")=request.form("phone2")
    > oRS("confnum")=request.form("confnum")
    > oRS.update
    > oRS.close
    > set oRS=Nothing
    > %>
    > What am I missing,,,,I'm going nuts. Easy to tell I'm a little new at
    > this stuff. Any help would be helpful Thank you
    George Ter-Saakov, Oct 30, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steven Baeten

    ADODB.connection safety settings error

    Steven Baeten, May 7, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    2,816
    Mary Chipman
    May 9, 2004
  2. msnews.microsoft.com
    Replies:
    2
    Views:
    674
    Luke Xu
    Oct 9, 2007
  3. Steven Baeten

    ADODB.connection safety settings error

    Steven Baeten, May 7, 2004, in forum: ASP .Net Security
    Replies:
    0
    Views:
    150
    Steven Baeten
    May 7, 2004
  4. Tom Petersen

    Connection error: ADODB.Recordset (0x800A0E7D)

    Tom Petersen, Sep 16, 2003, in forum: ASP General
    Replies:
    2
    Views:
    210
    Tom Petersen
    Sep 16, 2003
  5. Replies:
    2
    Views:
    230
    Bullschmidt
    Oct 25, 2005
Loading...

Share This Page