ADODB.Connection error '800a0e7c'

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
 
G

George Ter-Saakov

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.
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,007
Latest member
obedient dusk

Latest Threads

Top