- LOOKING FOR ORACLE 8I FOR WINDOWS NT HOW TO
- LOOKING FOR ORACLE 8I FOR WINDOWS NT INSTALL
- LOOKING FOR ORACLE 8I FOR WINDOWS NT DRIVER
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.
LOOKING FOR ORACLE 8I FOR WINDOWS NT INSTALL
Install the driver you want on the computer that is running SQL Server. 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.
LOOKING FOR ORACLE 8I FOR WINDOWS NT 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.