BUG: Setting Data Using DBTYPE_STR Binding Fails with OSP

ID: Q183592

The information in this article applies to:

OLE DB Simple Provider Toolkit, version 1.5
Microsoft Data Access Components version 2.1 SP2

SYMPTOMS

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.

CAUSE

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

RESOLUTION

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

STATUS

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.

Additional query words: OSPTK toolkit

Keywords : kbGrpMDAC oledb15Bug oledbOSP
Version : WINDOWS:1.5,2.1 SP2
Platform : WINDOWS
Issue type : kbbug