For some weird reason I cannot figure out how to properly code a stored proc to return a result set when executed through the OLE DB provider.

Shouldn't SELECT * FROM TableName in the stored proc return a record set that gets processed by the provider as a query result? Whenever I try this, all I get back is a return value of 1 and not the data that the stored proc is attempting to return.

What silly thing am I forgetting?

Laterness,
Jon