Supporting bookmarks

Hi,we have an OLEDB provider that we use as a linked server to join results
from an AltaVista index against a SQL Server 2000 view. Our SQL query is
something like:
select AllDocuments.TransactionID from AllDocuments,
OPENROWSET('onesource.avprovider','','SELECT * FROM NEWS WHERE
$boolean_query=''(ReportType:("news"))''
and $max_hits=10 ORDER BY #time desc') as AV
where AllDocuments.transactionid = convert(varchar(128),[$docid]) order by
StorydateTime  DESC

Unfortunately, we get the error:
OLE DB provider 'onesource.avprovider' supplied inconsistent metadata. The
object '(user generated expression)' was missing expected column 'Bmk1000'.

Speaking to Microsoft, they told me to implement bookmarks, as shown at the
URL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vccore/html/vcconprovidersupportforbookmarks.asp

I followed the instructions, adapting to my provider, and I still get the
same error. It's really interesting that the identifier 'Bmk1000' is
mentioned in the error...sounds like something hardcoded in SQLServer!! One
of the parts of the implementation is writing a function to report column
metadata, yet it still doesn't work.

Any help would be greatly appreciated. Thanks!
Harris

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.