(This forum heading says "access TO Sql Server", but I don't know where else to file this question.)I am running Windows Server 2008 R2 64-bit with SQL Server 2008 64-bit. I am using Oracle Provider for OLE DB for a Linked Server
to Oracle 11g with the Oracle 11g client. If I run "SELECT from an Oracle view" in Management Studio it returns data just fine. If that SELECT is used as the definition of a SQL Server view, and a SELECT is done from that view, I get an error:
Msg 7356, Level 16, State 1, Line 2 The OLE DB provider "OraOLEDB.Oracle" for linked server "P101" supplied inconsistent metadata for a column. The column "DATESTAT" (compile-time ordinal 6) of object ""S4250000"."SIGNED_CONTRACTS"" was reported to
have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 16 at run time.
I am aware of the difficulties of dealing with dates between SQL Server and Oracle. In fact we will probably circumvent our problem by creating a custom view in Oracle with all the CAST functions to make the dates tolerable.
I would still like to know more about why the dates are handled when the bare select from Oracle is executed, but they are not handled when the same
View Complete Post