Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
PRB: Distributed Queries Return Error 7356 with MSDAORA
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