Hi,

I have a slight variation of the same problem. I am querying a number of 
files, html, PDF, text files etc using Microsoft Index Server. When 
returning data from the index server I am displaying as a hitlist - list 
of search results - on an ASP page. 

Sometimes for no apparent reason - there seems to be no pattern - a page 
will kick up an exception error with the exact same error message. 
However, when I refresh the page the error dissapears. Is this the normal 
behaviour? Could you remove your error by refreshing the page?

The microsoft article mentioned in a follow up talks about BLOB fields 
from SQL server. So I'm not sure if the fix from that article is going to 
apply to my problem. I have downloaded MDAC 2.7 components and the error 
still seems to exist. Do you have any ideas from your experiences or can 
anyone else help me?

Jules

> Can ASP handle the SQL text datatype ?
> 
> When I try to use it in my ASP page it returns the following error ...
> 
> 	error '80020009' 
> 	Exception occurred. 
> 
> Any ideas ?
> 
> Thanks for your help.