Solved

Error in Classic ASP

Posted on 2009-04-15
2
179 Views
Last Modified: 2012-05-06
Hi,

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?

Regards

Glenn


set rs=Server.CreateObject("ADODB.Recordset")

	rs.open "Member",conn,3,2

	rs.addnew

			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
 

	rs.update

	rs.close

	set rs=nothing

Open in new window

0
Comment
Question by:dotsandcoms
2 Comments
 
LVL 29

Accepted Solution

by:
David H.H.Lee earned 500 total points
ID: 24146601
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:
http://databases.aspfaq.com/database/what-is-this-multiple-step-ole-db-error.html
0
 

Author Closing Comment

by:dotsandcoms
ID: 31570359
good one
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now