Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracl
763982Dec 21 2010 — edited Dec 23 2010I have created a linked server in a SQL Server 2005 connecting to either an Oracle Database and a SQL Server 6.5 database and getting the following error for both links when trying to query using provider OraOLEDB.Oracle, please help.
OLE DB provider "OraOLEDB.Oracle" for linked server "finprod3" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "finprod3".