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?
Who is Participating?
WaynepiConnect With a Mentor Commented:
Its a fairly easy process though.Download the 32bit client from oracle.
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.
mcv22Connect With a Mentor Commented:
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.
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.

All Courses

From novice to tech pro — start learning today.