Follow via:
RSS
Email Alert
Question
0 Votes
+ -

Creating a MS SQL Server Linked Table to Oracle

I apologize if this has been asked already, but I was unable to find it. (If it has been, please post a link to the answer.)

Does anyone know how to create a Linked Server in MS SQL to pull data from an Oracle 10g (I think) database? I have the Oracle ODBC drivers, etc, but I need all the steps to creating the Linked Server and then what I should use for the query.

Thanks!
19th Feb 2009
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.