I have trouble making a linked server from a SQL Server 2008 R2 64bit to an Oracle database. I have a linked servers on a few other PCs working fine to this same Oracle server.
On this particular one, I configured the following and Command Test connection shows that it is working fine:
But when I tried to create the linked server as shown below, it fails.
The error is:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "CARE".
OLE DB provider "OraOLEDB.Oracle" for linked server "CARE" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". (Microsoft SQL Server, Error: 7303)
I can't find what other parameters I could adjust. How should I go about solving this problem. Thanks.
View Complete Post