Rotating ad banner script errors

[hallm]

I've found an example ad rotation script that will do work for what I'm trying to do with my online newspaper.&nbsp;&nbsp;I get the same error every time I try to run it.&nbsp;&nbsp;What am I doing wrong?<br><br>Error:&nbsp;&nbsp;Microsoft OLE DB Provider for ODBC Drivers error '80040e24' <br>The rowset does not support fetching backwards <br>/news/start2.asp, line 154<br><br>&lt;%<br>set rotatingad = db.execute(&quot;SELECT * FROM ads2&quot<br><br>Dim rndMax, rndNumber<br>Dim BID, imagefile, url<br>Randomize<br>rndMax = Int(rotatingad.RecordCount)<br>rndNumber = Int(RND * rndMax)<br><br>rotatingad.Move rndNumber<br>BID = rotatingad(&quot;BID&quot<br>imagefile = rotatingad(&quot;imagefile&quot<br>url = rotatingad(&quot;url&quot<br>%&gt;<br><br>&lt;a href = &quot;adsredirect.asp?ID=&lt;%=BID%&gt;&quot; TARGET=&quot;_blank&quot;&gt;&lt;IMG height=&quot;71&quot; width=&quot;155&quot; SRC=&quot;<A HREF="

http://www.sabinenews.com/sads/&lt"

TARGET="_new">

http://www.sabinenews.com/sads/&lt</A>;%=url%&gt;&quot;

BORDER = 0&gt;&lt;/a&gt;<br>