November 29, 2010 at 6:57 am
Hi All,
Working with SQL Server 2008 R2. I've created a Linked server to an Oracle source, but when I right click on the Linked Server name and test it, it fails with the following:
Cannot initialize the data source "OraOLEDB.Oracle" for linked server "LinkedServername"
OLE.DB provider "OraOLEDB.Oracle" for linked server "LinkedServername" retunred message "ORA-12154:TNS:Could not resolve the connect identifier specified".
I've successfully created the System DSN in ODBC Data Source Administrator, and when I test the data source from there it completes successfully.
Thanks
Denesh
November 29, 2010 at 7:00 am
Don't cross-post please.
Replies here:
http://qa.sqlservercentral.com/Forums/FindPost1027299.aspx
-- Gianluca Sartori
November 29, 2010 at 7:05 am
Hi Gianluca,
Apologies for that...wasn't sure if I'd posted in the right forum
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply