Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    240

    Unanswered: View with Linked Oracle Server

    Hi,

    I have created a linked server to oracle, which works fine.
    But when I try and create a view joining the SQL table with the linked Oracle table, it only returns the primary key field in the Oracle table and nothing else.

    Anyone know why?

    Thanks

    N.B. I'm using SQL Server 2005 btw.
    <- Hides behind a rock.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    At least at first, I'd bet on Oracle permissions for the linked server login.

    -PatP

  3. #3
    Join Date
    Sep 2005
    Posts
    240
    I use the same username and password when running queries in Access linked to the same Oracle server. And these run fine.
    <- Hides behind a rock.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •