0 Replies Latest reply: Apr 25, 2011 4:46 PM by 543686 RSS

    Getting ora12154 on linked server creation, both tnsping and sqlplus work.

    543686
      I thought I was home free with both tnsping and sqlplus working and connecting with no issues (on the mssql box).

      I'm trying to get a linked server set up on my mssql box. When I try, using either Oracle's own or Microsoft's provider, the test connection fails with ora-12154 (can't resolve server name) error.

      There is only 1 oracle client installed on my mssql box. Environment vars set for oracle_home and tnsadmin. "Allow in process" is checked on the mssql database for both Oracle and MS-Oracle providers.

      What setup issue could there be, that results in ONLY sql server not being able to resolve an oracle db name?

      Thanks for any suggestions,
      sff

      Edited by: sherifffruitfly on Apr 25, 2011 2:42 PM