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

  • Try running with what you have. Open up SSMS, connect to your instance and go to Server Objects > Linked Servers > Providers. Follow the steps from the blog post and see if you can get connected with one of the Oracle drivers from that list.

    There's info on the web on how to do a complete un-install of the Oracle client, I'm pretty sure it's actually buried in the layers of the Oracle documentation (yeah, Oracle doc navigation is rough). Try this one: http://docs.oracle.com/html/B10131_02/deinstall.htm#i1008427

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

    Yeah, well...The Dude abides.