Creating a Rowset with IOpenRowset

The SQL Native Client OLE DB provider supports the IOpenRowset::OpenRowset method with the following restrictions:

  • A base table or view must be specified in a database ID (DBID) structure that the pTableID parameter points to.
  • The DBID eKind member must indicate DBKIND_NAME.
  • The DBID uName member must specify the 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 that contain a single rowset can be supported by Microsoft SQL Server cursors. Cursor support allows the developer to use SQL Server concurrency mechanisms.

See Also

Concepts

Rowsets

Help and Information

Getting SQL Server 2005 Assistance