Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172531

From BetaArchive Wiki
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