By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,963 Members | 1,778 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,963 IT Pros & Developers. It's quick & easy.

ADODB.Connection error '800a0e7c'

P: n/a
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
Nov 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <sh***@hillstax.org> wrote in message
news:d9**************************@posting.google.c om...
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

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.