I've set up a linked server to the Index Service. Using the debugger in SQL i've tested my sproc and it returns the filename & size of various files.

On the UI side, if I attach an adodc to the sproc and a datacombo to the adodc i get a recordset returned. But, if I attempt to do this through a recordset I get -1 records returned.

Any ideas?