If you receive this error 

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

you will need to check the state of the recordset as in the code below before you access any properties of the object

if not oRs.state <> 1 then

        if not oRs.eof then

              if oRs("Value").Value > 0 then
                 myval = oRs("Value").Value
            else
           myval = 0     
            end if
        end if
    else
        Response.Write "Cannot find any records"
    end if