SQL Server Performance

sqlserver2005 limitation to extract TIMESTAMP data

Discussion in 'SQL Server 2005 Integration Services' started by Sheetal, Oct 26, 2007.

  1. Sheetal New Member

    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?
  2. satya Moderator

Share This Page