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?