Hi,

I am using Microsoft Inder Server to search a web site and provide 
searching capablities for web users. This searches multiple file types, 
html, pdf and text to name a few. Once these have been returned in a 
recordset they are out into an array, not using getrows() but simply 
stepping through the recordset and putting into multiple arrays. This 
provided better performance than getRows().

The array of results is then displayed to users on ASP pages, 10, 20 or 30 
reuslts at a time. Sometimes, for no apparent reason, and there seems to 
be no pattern, a page displays the error message...

error '80020009'

Exception occured.

Then, if I refresh the page, the error disappears - is this normal 
behaviour? Has anyone else experienced this problem?

For a little more info, the recordset returned can have around 500 records 
returned, the first 120 are sorted into an array and then they are 
displayed, if a user moves to a page that contains records greater than 
120, the code goes to the recordset, stored in memory, and gets the next 
120 records to display.

I went to Microsoft and read the following article...

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q175239&LN=EN-
US&SD=gn&FR=0

It mentioned that the problem should disappear if MDAC 2.1 or greater is 
being used, I am using MDAC 2.6 components. Also, it mentions it as a SQL 
Server problem.

Anyone have any ideas?