Microsoft KB Archive/172531

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 15:36, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

BUG: IDBSchemaRowset Reports DBTYPE_NUMERIC for MONEY Datatype

Article ID: 172531

Article Last Modified on 5/2/2001


  • Microsoft OLE DB 1.1

This article was previously published under Q172531

BUG #: 4643 (OLEDSDK)


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.


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


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: kbbug kbprogramming KB172531