Link to home
Start Free TrialLog in
Avatar of cwpannell
cwpannell

asked on

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?
SOLUTION
Avatar of mcv22
mcv22
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial