Post reply

Linked Server to Oracle Data Source Fails

  • November 29, 2010 at 6:57 am

    #227664

    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

    #1256229

    Don't cross-post please.

    Replies here:

    http://qa.sqlservercentral.com/Forums/FindPost1027299.aspx

    -- Gianluca Sartori

  • November 29, 2010 at 7:05 am

    #1256231

    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