BOF and EOF error

<i><b>Originally posted by : z</b></i><br /><br />I would like to display "No Records Found" by using this statement:<br /><br /> <% If oRSA.EOF Then %> <br /><h3 align=center><% Response.write("No Records Found") %></h3><br /><% Else %><br /> <% Do While Not oRSA.EOF %><br /><br />but I am getting this message:<br /><br />ADODB.Field error '80020009' <br /><br />Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. <br /><br />Please help! <br />

<i><b>Originally posted by : Mage (mage@baltnet.ru)</b></i><br />Hi!<br /><br />What type of fields do you have in your DB? This error could happen if you have text or blob fileds. If so try to retrieve these type of fields as last fields in a query (and move them to last places in SQL DB).<br />Another case - may be you have your recordset created as DTC? If so try not to use DTC. If you still want to use DTC try to delete and recreate your DataCommand and also rebuild DSN you're using.<br />Moreover Microsoft suggests to install service pack 3 for your Visual Studio.<br /><br />Hope this helps,<br />Mage<br /><br />------------<br />z at 3/27/2001 3:03:17 PM<br /><br /><br />I would like to display "No Records Found" by using this statement:<br /><br /> <% If oRSA.EOF Then %> <br /><h3 align=center>No Records Found</h3><br /><% Else<br /> Do While Not oRSA.EOF %><br /><br />but I am getting this message:<br /><br />ADODB.Field error '80020009' <br /><br />Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. <br /><br />Please help! <br />