BUG: Error When You Set the "Server Data on Insert" Property and Open a Recordset (304253)
The information in this article applies to:
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.6 SP1
- Microsoft Data Access Components 2.7
This article was previously published under Q304253 SYMPTOMS
If you try to set the Server Data on Insert dynamic property of the ADODB Command object and then open a recordset based on the command, you receive the following error message:
-2147217887 The requested properties cannot be supported
Alternatively, you may not receive an error message, but accessing the recordset fields may return null.
CAUSE
The cursor service does not support the DBPROP_SERVERDATAONINSERT dynamic property, even if the underlying data provider supports it. You do not receive the above-mentioned error message with some providers because some cursor engines do not produce an error on the DBPROP_SERVERDATAONINSERT dynamic property.
STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 5/8/2003 |
---|
Keywords: | kbbug kbpending KB304253 |
---|
|