June 21, 2018 at 7:53 am
Last week, we moved a database from one test server to a new test server. We're now receiving this error message when we attempt to execute a Table Valued Function that accesses Oracle data via a linked server. Our DBA has confirmed that the settings for the Linked Server matches those on the original test server as well as the linked server in Production. Any ideas?
Msg 7356, Level 16, State 1, Line 5
The OLE DB provider "OraOLEDB.Oracle" for linked server "[Server Name Deleted]" supplied inconsistent metadata for a column. The column "[Column Name Deleted]" (compile-time ordinal 27) of object "Schema & Table Names Deleted" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time.
June 21, 2018 at 7:59 am
david.holley - Thursday, June 21, 2018 7:53 AMLast week, we moved a database from one test server to a new test server. We're now receiving this error message when we attempt to execute a Table Valued Function that accesses Oracle data via a linked server. Our DBA has confirmed that the settings for the Linked Server matches those on the original test server as well as the linked server in Production. Any ideas?
Msg 7356, Level 16, State 1, Line 5The OLE DB provider "OraOLEDB.Oracle" for linked server "[Server Name Deleted]" supplied inconsistent metadata for a column. The column "[Column Name Deleted]" (compile-time ordinal 27) of object "Schema & Table Names Deleted" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time.
Did you also verify the version and configuration of the Oracle provider? Provider/Driver versions is another one that can cause that error.
Sue
June 22, 2018 at 12:58 pm
I'm working w Dave Holley on this issue.
There are some minor differences between the environments:
The one that works has :
2012 Server; 2012 db
The one that doesn’t work has :
2012 R2 Server; 2014 db;
Collation on both is the same.
Oracle client is 11.2.0.1 64-bit on both and first in the PATH.
Compatibility is 2012 110 on both.
Linked server settings are identical on both.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply