SQLCrazyCertified (12/31/2012)
Hi Lowell,I don't exactly follow all the steps you mentioned above.
Can you please provide step by step for example, I want to create a
Linkedserver from SQL to Oracle.
What are the steps involved from beginning to end and do I need to contact
Oracle team to accomplish this?
Thanks in advance.
SueTons.
SueTons you've got to establish basic connectivity to the Oracle Server(s) on the SQL server itself just like any other desktop that connects. That means using Oracle tools, before you can can create a linked server that uses that connectivity. that's step one, and you certainly could get the Oracle team involved; they probably do the same step to every new machine that gets added to your company.
It will absolutely require the Oracle Client tools installation from the Universal installer.
once you've got that, editing the linked server example should be very straight forward.
let us know where you are at so we can offer some better suggestions.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!