I am getting this error during a insert from asp page into a oracle database.<BR><BR>Microsoft Cursor Engine error &#039;80004005&#039; <BR>Insufficient key column information for updating or refreshing.<BR><BR>heres the code<BR><BR>set rs1 = server.createobject("adodb.recordset")<BR>rs1.Open "SELECT shillim_msg_seq.CurrVal AS seqid FROM dual",Conn,1,2<BR>seqid = rs1("seqid")<BR>rs1.close<BR><BR>set rs2 = server.createobject("adodb.recordset")<BR>rs2.curs orlocation=3<BR>rs2.locktype = 3<BR>rs2.open "select msg from shillim_message where id=" & seqid, Conn<BR>&#039;** append in chunks to the long field<BR>&#039;lenth = Len(msg);<BR>&#039;response.write(Len(msg))<BR>res ponse.write seqid &"<BR>"<BR>blnSupported = rs2.Supports(adUpdate)<BR>response.Write blnSupported & "<BR>"<BR>For i=1 To Len(msg)<BR> value=Mid(msg, i, 2000)<BR> response.write(value & " " & i & "<BR>")<BR> rs2.fields("msg").appendchunk(value)<BR> i = i + 1999<BR>Next<BR>rs2.update -----&#062;&#062; ERROR LINE<BR>rs2.close<BR><BR>I am getting the above error on rs2.update line. I have ado 2.6.<BR><BR>bri j<BR>