This is the error we are receiving: OLE DB provider "OraOLEDB.Oracle" for linked server "ORADEV" returned message "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA".
We are executing a stored procedure from .net code or directly calling it from sql management studio on a Windows server 2008 R2 machine. The stored procedure is stored on a seperate server running Sql Server 2008 R2 which has a link configured to a Oracle 10G database.
The stored procedure does some xml parsing etc and then goes to insert data into oracle.
When the stored procedure is called directly on the sql server machine everything works correctly.
The linked server configuration uses an oracle user account to access the Oracle database.
Thanks for any help.
Simon
