0

I have two instances (SQL2008R2_A and SQL2008R2_B), they have same linked server configuration to Oracle_C. I used the same query to select from Oracle_C. SQL2008R2_A returned the correct result but SQL2008R2_B get nothing. And I tested linked server connection of both instances. They are all successfully. Interesting...

asked Sep 16, 2017 at 7:55
2
  • 1
    The linked servers might look the same, but something should be different if the same query is returning different results. Check the configurations side-by-side, check security settings and accounts used in the linked servers, and (maybe) the driver? Just some guesses at things to look at. Commented Sep 16, 2017 at 10:29
  • 1
    Are you sure your TNS names files are exactly the same on both SQL systems? Commented Sep 16, 2017 at 12:00

1 Answer 1

0

Thank you for your response. Before post this question I already double checked the settings for both linked server and TNS name file. There is nothing different between them.

Fortunately, I resolved it by just re-create the linked server at Server B. It might need to refresh some cache.

Thanks again and have a great one:)

answered Sep 18, 2017 at 12:43

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.