• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

Error in Classic ASP


I am getting the below error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I am using the DSN connection.

Can any one tell me why i am getting this type of error?



set rs=Server.CreateObject("ADODB.Recordset")
	rs.open "Member",conn,3,2
			rs("uname") = username
			rs("password") = password
			rs("sq") = sq
			rs("sa") = sa
			rs("title") = title
			rs("fname") = firstname
			rs("lname") = lastname
			rs("gender") = gen
			rs("dob") = dob
			rs("address") = address
			rs("city") = city
			rs("zip") = zip
			rs("state") = state
			rs("country") = country
			rs("phone") = phone
			rs("mobile") = mobile
			rs("email") = email
			rs("tc") = tc
			rs("mdate") = date
			rs("approve") = 1
	set rs=nothing

Open in new window

1 Solution
David H.H.LeeCommented:
Hi dotsandcoms,
This is common datatype problem.
Make sure you are passing valid datatypes to whatever is going on in the database. For example, check that you are not passing a NULL or empty string value to a column that doesn't accept them (either manually defined or, say, a DATETIME column). Make sure that all VARCHAR lengths and numeric bounds are adhered to.

Please check this for further details:
dotsandcomsAuthor Commented:
good one
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now