Article ID: 910454 - View products that this article applies to.
In Microsoft Host Integration Server, you may receive an error message that is similar to the following when you issue an SQL query statement:
This behavior occurs if the following conditions are true:
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].
Host Integration Server data providers do not support user-defined data types.
To work around this behavior, use one of the following methods:
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.