My Oracle Support Banner

How to Create a Sql Server Linked Server With The Oracle Provider for OLE DB or Oracle ODBC Driver (Doc ID 191368.1)

Last updated on OCTOBER 20, 2019

Applies to:

Oracle ODBC Driver - Version 9.2.0.8 and later
Oracle Provider for OLE DB - Version 9.2.0.8 and later
Generic Windows
Sql Server 2000
Sql Server 2005
Sql Server 2008


***Checked for relevance on 24-Dec-2018***

Purpose

The purpose of this document is to show the steps needed to create a linked server in Microsoft SQL Server to use either the Microsoft SQL Analyzer query tool (32-bit) or Microsoft SQL Server Management Studio with the Oracle Provider for OLE DB. This will enable the user to use the 4 part query naming convention in SQL Analyzer/Management Studio. 

Scope

This note is intended for all audiences that have some knowledge of  SQL Analyzer, Oracle Provider for OLE and Microsoft SQL Server.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Instructions to Setup the 32-Bit Linked Server Connection with SQL Server 2000
 Instructions to Setup the 32-bit Linked Server Connection in SQL Server 2005 or SQL Server 2008 or SQL Server 2012 Using the Oracle Provider for OLE DB
 Instructions to Setup the 64-bit Linked Server Connection in SQL Server 2005 or SQL Server 2008 or SQL Server 2012 Using the Oracle Provider for OLE DB
 Instructions to Setup the 32-bit / 64-bit Linked Server Connection in SQL Server 2005 or SQL Server 2008 or SQL Server 2012 Using the Oracle ODBC Driver

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.