Post reply

How to select from the linked oracle server?

  • December 21, 2007 at 10:41 am

    #182157

    Hi,

    I can add a linked oracle server to sql 2000 server. But I tried to run

    select * from linkedServerName.schema.tableName.

    The error said it's invalid object name. If I use

    select * from linkedServerName..schema.tableName

    It complains the OLE DB provider 'xxx' does not contain table schema.tableName.

    Can anyone help me?

    Thanks

  • December 21, 2007 at 10:43 am

    #762210

    Everything in the FROM clause MUST be all upper case...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 21, 2007 at 10:53 am

    #762217

    ahh, Thanks

    That works. I also found if I use openquery. it works too.

  • December 21, 2007 at 10:59 am

    #762221

    You bet... thanks for the feedback.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply