BUG: IDBSchemaRowset Reports DBTYPE_NUMERIC for MONEY Datatype

ID: Q172531

-----------------------------------------------------------------------

The information in this article applies to:

Microsoft OLEDB SDK, version 1.1

BUG #: 4643 (OLEDSDK)

SYMPTOMS

When an application queries SQL Server for the MONEY datatype using IDBSchemaRowset::GetRowset DBSCHEMA_COLUMNS, it returns DBTYPE_NUMERIC (131). This is inconsistent with IColumnsInfo::GetColumnInfo, which returns DBTYPE_CY (6) for the MONEY datatype.

WORKAROUND

To work around this problem, use IColumnsInfo::GetColumnInfo for the column metadata.

STATUS

Microsoft has confirmed this to be a problem in OLEDB SDK version 1.1. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: ODBC SQL_DECIMAL software developers developer's kit

Keywords : kbprg SSrvProg
Version : :1.1
Platform : WINDOWS
Issue type : kbbug