DOCUMENT:Q239719 11-SEP-2001 [odbc] TITLE :INFO: Support Limits of MS Oracle ODBC Driver/OLEDB Provider PRODUCT :Open Database Connectivity (ODBC) PROD/VER::2.0,2.1,Build 2.573.2927,Build 2.573.3513,Build 2.573.3711,Build 2.573.4202 OPER/SYS: KEYWORDS:kbDriver kbODBC kbOLEDB kbOracle kbProvider kbGrpDSVCDB kbGrpDSMDAC kbMDACNoSweep ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft ODBC for Oracle version 2.5, versions Build 2.573.2927, Build 2.573.3513, Build 2.573.3711, Build 2.573.4202 - Microsoft OLE DB Provider for Oracle, versions 2.0, 2.1 ------------------------------------------------------------------------------- SUMMARY ======= The Microsoft ODBC Driver for Oracle (MSORCL32.DLL) version 2.573.4202 (and earlier versions) and the Microsoft OLE DB Provider for Oracle (MSDAORA.DLL) version 2.10.4202 (and earlier versions)have not been tested with Oracle 8i. So connectivity to Oracle 8i is not supported with this version or earlier versions of the Microsoft Driver/Provider. They have been successfully tested to run with the Oracle 8.x (excluding Oracle 8i) client software going against an Oracle 8.x server. MORE INFORMATION ================ The Microsoft ODBC Driver for Oracle version 2.573.4202 and the Microsoft OLE DB Provider for Oracle version 2.10.4202 do not support any Oracle 8.x specific (including Oracle 8i) features. Oracle 8.x specific datatypes are one such example of an unsupported feature. Datatypes such as CLOB, BLOB, BFILE, NCHAR, NCLOB, NVARCHAR2, which were introduced with Oracle 8.x, are not supported using this version or earlier versions of the Microsoft Driver/Provider. The MDAC 2.5 versions of the provider (2.50.4403) and driver (2.573.4403) were tested against Oracle 8i servers and support connectivity. If Oracle 8i connectivity is required please upgrade to at least the MDAC 2.5 version of the provider and driver. REFERENCES ========== Information on the system requirements needed to use the Microsoft ODBC Driver/OLEDB Provider can be obtained from the MSOracle32Readme.txt file for the Driver/Provider. For additional information, click the article number below to view the article in the Microsoft Knowledge Base: Q244661 INFO: Microsoft Oracle ODBC Driver and Provider Support Connectivity to Oracle 8i Additional query words: Oracle8i msorcl32.dll msdaora.dll Oracle8.x ====================================================================== Keywords : kbDriver kbODBC kbOLEDB kbOracle kbProvider kbGrpDSVCDB kbGrpDSMDAC kbMDACNoSweep Technology : kbAudDeveloper kbODBCSearch kbOLEDBSearch kbODBCOracle25732927 kbODBCOracle25733513 kbODBCOracle25733711 kbODBCOracle25734202 kbOLEDBProvOracle200 kbOLEDBProvOracle210 kbOLEDBProvSearch kbODBCOracle250Search Version : :2.0,2.1,Build 2.573.2927,Build 2.573.3513,Build 2.573.3711,Build 2.573.4202 Hardware : ALPHA x86 Issue type : kbinfo ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.