title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Create rowset with IOpenRowset (OLE DB driver) |
Learn how OLE DB Driver for SQL Server supports the IOpenRowset::OpenRowset method to return a rowset and restrictions on its use. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
[!INCLUDE SQL Server]
[!INCLUDEDriver_OLEDB_Download]
The OLE DB Driver for SQL Server 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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] cursors. Cursor support allows the developer to use [!INCLUDEssNoVersion] concurrency mechanisms.