Solved

Adding Oracle as a linked server in SQL Server 2005

Posted on 2010-08-17
5
284 Views
Last Modified: 2012-05-10
What are the requirements when setting up an Oracle DB server as a linked server to a SQL Server 2005 server?  Do you have to install Oracle client or can you just install the Microsoft OLE DB Provider for Oracle only?
0
Comment
Question by:cwpannell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 12

Assisted Solution

by:mcv22
mcv22 earned 200 total points
ID: 33460007
0
 
LVL 12

Assisted Solution

by:mcv22
mcv22 earned 200 total points
ID: 33460009
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33460018
Except for a JDBC connection: to connect to an Oracle Database you need an Oracle client.

You might be able to use the InstantClient which is the smallest install footprint.
0
 
LVL 14

Assisted Solution

by:Dhanasekaran Sengodan
Dhanasekaran Sengodan earned 100 total points
ID: 33463201
0
 
LVL 1

Accepted Solution

by:
Waynepi earned 200 total points
ID: 33464199
Hi,
Its a fairly easy process though.Download the 32bit client from oracle.
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Install package and go to link servers select ORICLE PROVIDER FOR OLE DB.
Make sure that you datasource point to the Oricle server including it port.
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question