You may receive an "OLE DB provider '<Provider Name>' supplied inconsistent metadata for a column" error message when you issue an SQL query statement against a DB2 table in Host Integration Server (910454)
The information in this article applies to:
- Microsoft Host Integration Server 2004
- Microsoft Host Integration Server 2000
SYMPTOMSIn Microsoft Host Integration Server, you may receive an error message that is similar to the following when you issue an SQL query statement: Server: Msg 7356,Level 16,State 1,Line 1
OLE DB provider 'Provider Name' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'columnID' (compile-time ordinal 5) of object ' SQL_instance.Database_name.table_name ' was reported to have a DBTYPE of 128 at compile time and 129 at run time].
This behavior occurs if the following conditions are true: - You issue a four-part SQL query statement against an IBM DB2 table.
- The DB2 table contains a column that has a user-defined data type.
CAUSEHost Integration Server data providers do not support user-defined data types.STATUS
This behavior is by design.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
| Modification Type: | Major | Last Reviewed: | 2/6/2006 |
|---|
| Keywords: | kbinfo kbhis2000 kbHIS2004 kbprb kberrmsg KB910454 |
|---|
|