<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am getting the below error:<br />
<br />
Microsoft OLE DB Provider for ODBC Drivers error '80040e21' <br />
<br />
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. <br />
<br />
I am using the DSN connection. <br />
<br />
Can any one tell me why i am getting this type of error?<br />
<br />
Regards<br />
<br />
Glenn<br />
<br />
<br />

<pre><code id="code-299470">set rs=Server.CreateObject(&quot;ADODB.Recordset&quot;)
	rs.open &quot;Member&quot;,conn,3,2
	rs.addnew
			rs(&quot;uname&quot;) = username
			rs(&quot;password&quot;) = password
			rs(&quot;sq&quot;) = sq
			rs(&quot;sa&quot;) = sa
			rs(&quot;title&quot;) = title
			rs(&quot;fname&quot;) = firstname
			rs(&quot;lname&quot;) = lastname
			rs(&quot;gender&quot;) = gen
			rs(&quot;dob&quot;) = dob
			rs(&quot;address&quot;) = address
			rs(&quot;city&quot;) = city
			rs(&quot;zip&quot;) = zip
			rs(&quot;state&quot;) = state
			rs(&quot;country&quot;) = country
			rs(&quot;phone&quot;) = phone
			rs(&quot;mobile&quot;) = mobile
			rs(&quot;email&quot;) = email
			rs(&quot;tc&quot;) = tc
			rs(&quot;mdate&quot;) = date
			rs(&quot;approve&quot;) = 1 
	rs.update
	rs.close
	set rs=nothing
</code></pre>
</div>
</div>


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



Error in Classic ASP

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.