BUG: Setting Data Using DBTYPE_STR Binding Fails with OSP

The Microsoft OLE DB SDK contains the Microsoft OLE DB Simple Provider (Msdaosp.dll) file.

When you try to set a column of a simple provider by binding with type DBTYPE_STR and calling IRowsetChange::SetData() or IRowsetChange::InsertRow(), the column will not be updated. The setVariant() method of the user written OSP object will not be called.

This is caused by a bug in the OLE DB Simple Provider, Msdaosp.dll file.

Use another DBTYPE for the DBBINDING object such as DBTYPE_BSTR or DBTYPE_WSTR.

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.