ADODB.Connection error '800a0e7c'

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

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
 
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.
 
Back
Top