Article ID: 172531
Article Last Modified on 5/2/2001
APPLIES TO
- Microsoft OLE DB 1.1
This article was previously published under Q172531
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: kbbug kbprogramming KB172531