Open Rowset Support Property

ADO and SQL Server

ADO and SQL Server

Open Rowset Support Property

The Open Rowset Support property returns a bitmask that specifies how the provider supports opening objects through the Connection object.

Applies To
Connection Object
Syntax

object.Properties("Open Rowset Support")

Parts

object

Expression that evaluates to an object in the Applies To list.

Returns

A bitmask containing one or more of the following settings:

Constant Description
DBPROPVAL_ORS_TABLE The provider supports opening tables through the Connection object (true for all providers).
DBPROPVAL_ORS_INDEX The provider supports specifying an index through the Connection object.
DBPROPVAL_ORS_INTEGRATEDINDEX The provider supports specifying both a table and an index in the same call to the Execute method in order to open the recordset using the specified index.
DBPROPVAL_ORS_STOREDPROC The provider supports opening a recordset over stored procedures by specifying the stored procedure name.
DBPROPVAL_ORS_HISTOGRAM The provider supports opening a histogram recordset using the Execute method.

Data Type

adInteger

Modifiable

Read-only

OLE DB Property

DBPROP_OPENROWSETSUPPORT