#LINKED SERVER SQL SERVER HOW TO#
#LINKED SERVER SQL SERVER INSTALL#
#LINKED SERVER SQL SERVER DRIVER#
#LINKED SERVER SQL SERVER SOFTWARE#

Restart the computer that is running SQL Server after you install the Oracle client software. OracleĬlient Microsoft Windows 2000 and later versions To enable MDAC 2.5, or later versions, to work with Oracle client software, the registry must be modified on the client computer that is running SQL Server as indicated in the following table. With MDAC 2.1, or with an earlier version, you cannot connect to databases that use Oracle 8. Make sure that you have MDAC 2.5, or a later version, installed on the computer that is running SQL Server. The client computer is the computer that is running SQL Server. You must install the Oracle 7.3.x client software, or a later version, on the client computer.

#LINKED SERVER SQL SERVER DRIVER#

If you use Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle, consider the following:īoth the OLE DB provider and the ODBC driver that are included with Microsoft Data Access Components (MDAC) require SQL*Net 2.3.x, or a later version. If you use a third-party provider or a third-party driver to connect to Oracle, you must contact the respective vendor for any problems that you may experience by using their provider or driver. Microsoft only supports Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle. Install the driver you want on the computer that is running SQL Server.

#LINKED SERVER SQL SERVER SOFTWARE#

You must install the Oracle client software on the computer that is running SQL Server where the linked server is set up. Steps to set up a linked server to Oracle Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products. The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Version greater than 8i are not supported using these drivers. Returning multiple resultsets from a stored procedure or batch SQL statement is not supported using ADO or OLEDB. Multiple Oracle client instances, or multiple Oracle homes, are not supported because they rely on the first occurrence of the Oracle home in the SYSTEM PATH variable. The Unicode feature against Oracle 7.x and 8.x servers is not supported. Oracle 8.x-specific data types, such as CLOB, BLOB, BFILE, NCHAR, NCLOB, and NVARCHAR2, are not supported. The Oracle client components are important, and must be configured correctly to successfully connect to Oracle databases using both the driver and the provider.įrom Microsoft Data Access Components (MDAC) version 2.5 and later versions, both the Microsoft ODBC Driver and OLE DB Provider support ONLY Oracle 7 and Oracle 8i with the following limitations: Both the driver and provider use the SQL*Net Client (or Net8 client for Oracle 8x) and the Oracle Call Interface (OCI) library, and other Oracle client components, to connect to Oracle databases and retrieve data. The current version of the Microsoft ODBC Driver for Oracle complies with the ODBC 2.5 specification, while the OLE DB Provider for Oracle is a native Oracle 7 OCI API provider.

#LINKED SERVER SQL SERVER HOW TO#

Instead, use Oracle's OLE DB provider.įor more information on configuring a linked server using Oracle’s OLEDB provider review How to get up and running with Oracle and Linked Servers. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Most of the information in this article is applicable to environments that are configured to use Microsoft OLEDB Provider for Oracle (MSDAORA). This article describes how to set up a linked server from a computer that is running Microsoft SQL Server to an Oracle database and provides basic troubleshooting steps for common errors you may experience when you set up a linked server to Oracle. Original product version: Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Workgroup Edition Original KB number: 280106 Summary This article describes how to set up a linked server from a computer that is running Microsoft SQL Server to an Oracle database and provides basic troubleshooting steps for common errors you may experience when you set up a linked server to an Oracle database.

Linked server sql server