VB Forum / Database Access / April 2005

Hi,

I have this code that is returning run-time error 7004. The rowset is not
bookmarkable.

Cn.CursorLocation = adUseServer
  Set iWebOrdLookup.ActiveConnection = Cn

     iWebOrdLookup.CommandType = adCmdStoredProc
     iWebOrdLookup.CommandText = "dbo.GetWebOrders_sp"
         Set rsWebOrd = New ADODB.Recordset ' ?

       rsWebOrd.CursorType = adOpenKeyset ' I have tried this ?
       rsWebOrd.LockType = adLockOptimistic ' I have tried this ?
       Set rsWebOrd = iWebOrdLookup.Execute

   If rsWebOrd.BOF = True And rsWebOrd.EOF = True Then
      MsgBox "No records match the Request Number ", vbOKOnly, "Message"
      Exit Sub
   Else
       Set grdGetWebOrders.DataSource = rsWebOrd
   End If

can someone advice please, I have looked at the knowledge base, and could
not figure it out.

Thanks
Dib