Article ID: 244661 - View products that this article applies to.
This article was previously published under Q244661
This article describes the limitations of the current version of Microsoft ODBC Driver and OLE DB Provider for Oracle. These components are currently in maintenance mode. No new updates are planned for future releases of these components including their support against versions later than Oracle 8i.
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. Both the driver and provider make OCI 7 API calls against the Oracle client components regardless of the Oracle version installed on the computer.
From 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:
For additional information, see the Help file that is included with the driver and provider. For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/259959/ )Techniques to debug connectivity issues to an Oracle server using the ODBC Driver and OLE DB Provider
(https://support.microsoft.com/kb/280106/ )How to set up and troubleshoot a linked server to Oracle in SQL Server
306787The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
(https://support.microsoft.com/kb/306787/ )PRB: Returning multiple resultsets fails under ADO with Microsoft Oracle OLEDB Provider and ODBC Driver
Article ID: 244661 - Last Review: July 8, 2009 - Revision: 8.0