How to select from the linked oracle server?

• iceheartjade

  Say Hey Kid

  Points: 677

  More actions

  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

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  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)
  

• iceheartjade

  Say Hey Kid

  Points: 677

  More actions

  December 21, 2007 at 10:53 am

  #762217

  ahh, Thanks

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

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  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)