0 Replies Latest reply: Oct 7, 2012 9:39 PM by 910430 RSS

    could not resolve the connect identifier specified - only in sql jobs

      windows 2008 R2 64 bit
      Sql Server 2008 R2 64 bit
      Oracle 11g R2 client 64bit

      I'm getting the 'ORA-12154: TNS:could not resolve the connect identifier specified' when I'm trying to execute a stored procedure that calls this linked server from a sql server agent job. I can execute the stored procedure perfectly fine in a query window. Any help or suggestions would be greatly appreciated.

      A little more info. The client install on this machine wasn't pretty. I think there might be multiple homes leading to confusion of which tnsnames.ora file the different elements are looking for. Anyway to verify this?

      Edited by: 907427 on Oct 7, 2012 7:38 PM