Home Forums SQL Server 2008 Working with Oracle Totally lost on creating a linked server from 2008R2 to Oracle RE: Totally lost on creating a linked server from 2008R2 to Oracle

  • I looked in the Oracle doc, you'll want to open and use the Oracle Net Configuration Assistant. It's the GUI that'll create and update your TNSNames.ora file:

    http://docs.oracle.com/cd/B19306_01/install.102/b15684/post_install.htm#CHDBIHEE

    Once you establish that connection, use that TNS name in as the @datasrc value from the blog.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.