SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MSSql linked server to Oracle db works locally, gives ora-12154 remotely?

543686Jan 26 2012 — edited Jan 26 2012

Hi all,

Installed client 32 bit 11.2.0 on the 32 bit mssql 2008r2 box. Setup a linked oracle server. When I'm on the mssql box (remote desktop), the linked server works exactly as expected, test connection, direct and openqueries all return expected results.

When I go back to my own workstation and connect to the mssql database via ssms, and run the same tests, they all fail with ora-12154.

On my own workstation I have oracle client successfully installed as well - I know this because I connect to oracle db's directly on a regular basis. I also have other mssql db's with oracle linked servers that work fine, both locally on the db box and remotely via my own workstation.

I'm at a loss to figure out what the issue even COULD be with this local-fine-remote-borked issue. Any tips?

Thanks for anything,
sff

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2012

Added on Jan 26 2012

2 comments

311 views