Article ID: 264012 - View products that this article applies to.
This article was previously published under Q264012
When you attempt to connect to an Oracle 8i database by using the Oracle 8i client and the Microsoft Oracle ODBC Driver (MSORCL32.DLL) version 2.573.4403 (or later) or the MS Oracle Provider (MSDAORA.DLL) version 2.50.4403.0 (or later), you may receive the following error message:
Error: "SQLSTATE: NA000
Native error code: 0
Driver Message: [Microsoft][ODBC Driver for Oracle][Oracle]
Do you need any suggestions to avoid the error?"
Different registry entries are necessary to ensure that various Oracle OCI versions operate correctly. To enable the OLE DB Provider or the ODBC Driver for Oracle to work with Oracle client software, the client's registry must be modified. The MDAC installation may not register the required registry entries.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
Change the registry setting as described in the "Known Issues for MDAC 2.5 RTM (2.50.4403.12)" section of the following release manifest:
MDAC2.5 Release ManifestThe following file is available for download from the Microsoft Download Center:
OraReg.exeFor additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
(http://support.microsoft.com/kb/119591/EN-US/ )How to Obtain Microsoft Support Files from Online Services
MDAC 2.5 is the first supported version of Microsoft Data Access Components for Oracle8i. You can download the latest version of MDAC from the following location:
http://msdn2.microsoft.com/en-us/data/aa937695.aspxThe table below shows the registry entries for each version of the Oracle Client described on the MDAC 2.5 Release Manifest webpage. These changes will also need to be made for MDAC 2.6 and 2.7.
Collapse this tableExpand this table
For Microsoft Windows 2000 or Windows XP systems:
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/239719/EN-US/ )INFO: Supportability of the Microsoft ODBC Driver/ OLE DB Provider for Oracle w.r.t Oracle 8.x
(http://support.microsoft.com/kb/244661/EN-US/ )FIX: Microsoft Oracle ODBC Driver and Provider Support Connectivity to Oracle 8i
Article ID: 264012 - Last Review: May 17, 2007 - Revision: 5.5