Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • 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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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