Creating a Rowset with IOpenRowset

OLE DB and SQL Server

OLE DB and SQL Server

Creating a Rowset with IOpenRowset

SQLOLEDB supports the IOpenRowset::OpenRowset method with the following restrictions:

  • A base table or view must be specified in a DBID structure that the pTableID parameter points to.

  • The DBID eKind member must indicate DBKIND_NAME.

  • The DBID uName member must specify name of an existing base table or a view as a Unicode character string.

  • The pIndexID parameter of OpenRowset must be NULL.

The result set of IOpenRowset::OpenRowset contains a single rowset. Result sets containing a single rowset can be supported by Microsoft® SQL Server™ 2000 cursors. Cursor support allows the developer to use SQL Server concurrency mechanisms.