Article ID: 251238 - View products that this article applies to.
This article was previously published under Q251238
If metadata information changes at execution time, the following error occurs:
This error may occur when you use distributed queries in SQL Server that reference a view if you create the underlying table in Oracle under the following conditions:
Server: Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column.
IDBSchemaRowset::GetRowset for DBSCHEMA_COLUMNS returns IS_NULLABLE as TRUE.
IColumnsInfo::GetColumnInfo on the rowset returns DBCOLUMNFLAGS_ISNULL as FALSE.
Because of the these discrepancies, distributed queries fail with the 7356 error.
The OLE DB provider, Msdaora.dll, returns the wrong information because the metadata that Oracle returns is incorrect.
Specify the Nullability of the column explicitly during the CREATE TABLE statement.
Steps to Reproduce BehaviorUse these steps to reproduce the behavior:
Article ID: 251238 - Last Review: July 14, 2004 - Revision: 3.2
Contact us for more help
Connect with Answer Desk for expert help.