Home Forums SQL Server 2008 SQL Server 2008 - General Linked server error RE: Linked server error

  • November 25, 2013 at 12:32 pm

    #1668947

    yes it is on the Oracle side; because of the _TS (_TIMESTAMP?) i think that it's the timestamp datatype issue.

    pretty sure you can also resolve this by convertint the value to string or a different datetime as well.

    you could find out the datatype via TSQL:

    untested, but i think this is the syntax

    SELECT * FROM [linkedserver]..[abc].[USER_TAB_COLS] WHERE TABLE_NAME = 'PERSON' AND COLUMN_NAME = 'INACTIVE_TS'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!