Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE DB Update Error (0x80040E21)

Status
Not open for further replies.

Sock

Programmer
Jun 28, 2002
4
US
Hey folks, this is my first questions so bear with me.
On part of my page i'm calling a sub that updates a recordset in a userlist. Here it is:

sub up_user (id, status)
dim who_status
rs.Open "SELECT * FROM ulist WHERE id=" & id, Conn
rs.movefirst
who_status = rs("status") & " " & status
rs("status") = who_status
rs.Update
rs.close
Response.Write &quot;Record id &quot; & id & &quot; updated to &quot; & status & &quot;<br>&quot;
end sub


Its being called with:
up_user request.querystring(&quot;id&quot;), request.querystring(&quot;status&quot;)
where the status is being appended to the current status.

I just transfered the database from access to mysql and its working fine and good until i started getting this error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/admin/admin_user.asp, line 74


Line 74 is refering to rs(&quot;status&quot;) = who_status

If anyone could lend a hand or idea as to why i'd be very thankfull.
-Nick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top