- #How to add hdbodbc driver to server 2008r2 how to#
- #How to add hdbodbc driver to server 2008r2 install#
- #How to add hdbodbc driver to server 2008r2 software#
#How to add hdbodbc driver to server 2008r2 install#
Install the driver you want on the computer that is running SQL Server.
#How to add hdbodbc driver to server 2008r2 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.
#How to add hdbodbc driver to server 2008r2 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.
0 kommentar(er)
