Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 244661 - Last Review: July 8, 2009 - Revision: 8.0
INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider
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:
- Oracle 8.x-specific data types, such as CLOB, BLOB, BFILE, NCHAR, NCLOB, and NVARCHAR2, are not supported.
- The Unicode feature against Oracle 7.x and 8.x servers is
not supported.
- 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.
- Returning multiple resultsets from a stored procedure or batch SQL statement is not supported using ADO or OLEDB.
For additional information about how to retrieve a resultset from an Oracle stored
procedure, click the following article numbers to view the articles in the Microsoft Knowledge Base:
255043Â
(http://kbalertz.com/Feedback.aspx?kbNumber=255043/
)
How to retrieve ADO recordset from
Oracle through ASP using REF CURSORS
176086Â
(http://kbalertz.com/Feedback.aspx?kbNumber=176086/EN-US/
)
HOWTO: Retrieve Recordsets from Oracle Stored Procs Using ADO
- Nested outer joins are not supported.
- XML persistence is not supported.
- Version greater than 8i are not supported using this drivers.
Important A
new Microsoft .NET Managed Oracle Provider that supports the Oracle 9i client
is now available. To download this provider, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=4F55D429-17DC-45EA-BFB3-076D1C052524
(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=4F55D429-17DC-45EA-BFB3-076D1C052524)
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:
259959Â
(http://kbalertz.com/Feedback.aspx?kbNumber=259959/
)
Techniques to debug connectivity issues to an Oracle server using
the ODBC Driver and OLE DB Provider
280106Â
(http://kbalertz.com/Feedback.aspx?kbNumber=280106/
)
How to set
up and troubleshoot a linked server to Oracle in SQL Server
306787Â
(http://kbalertz.com/Feedback.aspx?kbNumber=306787/
)
PRB:
Returning multiple resultsets fails under ADO with Microsoft Oracle OLEDB
Provider and ODBC Driver
The 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.
APPLIES TO
- Microsoft Data Access Components 2.5
- Microsoft Data Access Components 2.6
- Microsoft Data Access Components 2.7
- Microsoft ODBC for Oracle (Build 2.573.7626) 2.5
- Microsoft OLE DB Provider for Oracle Server 1.0
- Microsoft OLE DB Provider for Oracle Server 1.0
- Microsoft OLE DB Provider for Oracle Server 1.0
| kbdatabase kbdriver kbfix kbgrpdsmdac kbinfo kboracle kbprovider KB244661 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate