• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Adding Oracle as a linked server in SQL Server 2005

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
cwpannell
Asked:
cwpannell
4 Solutions
 
mcv22Commented:
0
 
mcv22Commented:
0
 
slightwv (䄆 Netminder) Commented:
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
 
WaynepiCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now