Aatish Patel (11/25/2013)
I create a linked server to Oracle in SQL 2008. tested the connection and it tests successfully.When I try to query
SELECT top 10 * FROM [linkedserver]..[abc].[persons]
GO
it fails with following error :
Msg 7354, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "W263UW" supplied invalid metadata for column "INACTIVE_TS".
The data type is not supported.
Pls help with this.
in Oracle, what is the datatype for the column INACTIVE_TS in the [persons] table?
if it's a TIMESTAMP, look at this post:
I've seen issues where an "old" drivers for Oracle version 9 is used agaisnt an Oracle version 10/11 database, and returns this kind of error for BLOB/CLOB columns;
the solution was to get a more updated Oracle driver installed on the SQL server to address the issue.
Lowell