dweil (2/4/2010)
I think you are getting closer now that you can connect via sqlplus.Search the entire computer to see if there is more then one copy of tnsnames on it.
In SMSS, right click on the linked server
Click script linked server as
Click create to
Click new query editor window
You might get a hint from the sql to create the linked server
You might also want to post the sql without any confidential information hidden
Cool, Ill have a go at that now 😀
I forgot to change it, can you edit the HOST and put MyServer on your previous post please, it wont let me edit it 🙂
Jez