Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    52

    Unanswered: SQl2005 - linked server

    Help pl.


    I need to access object from Oracle 9i. I've installed O9i client on sql server and create linked server to O9i db. but when executing

    exec sp_tables_ex N'SUN920' ---> list of all table appear

    and when selecting from a prticular table -- got below msg

    Msg 7314, Level 16, State 1, Line 2
    The OLE DB provider "OraOLEDB.Oracle" for linked server "sun920" does not contain the table ""shm"."x"". The table either does not exist or the current user does not have permissions on that table.

    how to resolve this issue

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My suggestion would be:

    1) If the table exists, grant the linked server user the needed permissions
    2) If the table does not exist, what did you expect?

    -PatP

  3. #3
    Join Date
    Mar 2005
    Posts
    52
    hI,

    TABLE EXISTS. in Sql the user is sa

    If I run exec sp_tables_ex N'SUN920' I got all tables and if try to select from particular table I gor the above error

Posting Permissions

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