Hi All,

I have (am developing) an OLE DB provider for a proprietary database format.
Among other things, I'd like to be able to browse the table contents from
the Server Explorer built into the Visual Studio 2003 IDE. At this point, I
am able to connect to my provider and browse the schema information (tables,
columns). However, an attempt to "Retrieve Data from Table" results in an
error message: "Item cannot be found in the collection corresponding to the
requested name or ordinal". I have verified in debugger that
IOpenRowset::OpenRowset() is not called. The message looks like something
originating in ADO (or ADO.Net?), perhaps a missing property? I have checked
which properties are requested from the data source object (session is not
queried) and found nothing suspicious.

My data provider supports IOpenRowset only, it doesn't create or support
commands. I have tried to connect to it from Visual Studio 2005 beta and
noticed that it tries to call IOpenRowset::OpenRowset() but passes in an SQL
statement instead of the table name! (the data source exposes
DBPROP_SQLSUPPORT with DBPROPVAL_SQL_NONE value but it doesn't seem to be
queried). Does Visual Studio 2003 also expect browsable OLE DB providers to
suport SQL unconditionally? What else might I be missing?

Thanks in advance for any ideas,
...Max...