BUG: IDBSchemaRowset Reports DBTYPE_NUMERIC for MONEY Datatype (172531)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 5/2/2001 |
|---|
| Keywords: | kbbug kbprogramming KB172531 |
|---|
|