Hjälp med sql

[mashen]

Hej jag har problem med ett uppdaterings script som ser ut så här<%

Set Connect = Server.CreateObject("ADODB.Connection")

Connect.Open "DSN=d5993-messages;Password=@01#$iiolmnjhhbmeooacnkjadklcbi"

Set RecSet = Server.CreateObject("ADODB.Recordset")

Addera = "Select * From message where fromid=" & Session("id")

RecSet.Open Addera, Connect,adOpenDynamic,adLockOptimistic

RecSet("tillID") = Request.Form("to")

RecSet("rubrik") = Request.Form("rubrik")

RecSet("text") = Request.Form("text")

RecSet("datum") = Date

RecSet("read") = 0

RecSet("namn") = Session("username")

RecSet("fromID") = Session("id")

RecSet.Update

RecSet.Close

 

Connect.close

Set RecSet = nothing

Set Connect = nothing

 

Response.Redirect "send_mess.asp?direct=no"

 

%>jag får felmeddelande

 

ADODB.Recordset.1 error '80004005'

 

SQLState: 34000

Native Error Code: 0

[iNTERSOLV][ODBC SequeLink driver]Statement with cursor named in this statement's CURRENT-OF-CURSOR clause is not a SELECT FOR UPDATE.

 

 

/comm/do_send.asp, line 16

TAcksam för hjälp

mvh

Martin