Hi, I have created one Linked server to fetch the data from Oracle server. I have two tables at Oracle server 1. EMP_Tbl1 (Emp_Cd VARCHAR2(10)) 2. EMP_Tbl2 (EMP_ID NUMBER, Emp_Cd VARCHAR2(10)) I can connect to EMP_Tbl1 table through my linked server at SQL Server 2005. WHILE I cann't connect to EMP_tbl2. ERROR: The OLE DB provider "OraOLEDB.Oracle" for linked server "Linked_Facets" supplied inconsistent metadata for a column. The column "EMPID" (compile-time ordinal 1) of object ""SYSTEM"."EMP_ASH"" was reported to have a "DBTYPE" of 5 at compile time and 130 at run time. Reason: EXEC sp_addlinkedserver @server='Linked_Facets' ,@srvproduct='ORACLE' ,@provider='OraOLEDB.Oracle'--'OraOLEDB.Oracle' ,@datasrc='ameri.corp.ads.valuelabs.net' I am using 'OraOLEDB.Oracle' as the provider. This has its own limitations. How to conquer this?
I think it is a Oracle inconsistency, http://forums.oracle.com/forums/thread.jspa?messageID=1042742 fyi.