PRB: Connectivity Issue with MDAC and Oracle8i (264012)


The information in this article applies to:

  • Microsoft OLE DB Provider for Oracle 2.5
  • Microsoft OLE DB Provider for Oracle 2.6
  • Microsoft OLE DB Provider for Oracle 2.7
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.3711
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.4403
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.6526
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.7713.2
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
This article was previously published under Q264012

SYMPTOMS

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?"

CAUSE

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.

RESOLUTION

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry


WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

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 Manifest

The following file is available for download from the Microsoft Download Center:

OraReg.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft 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.

MORE INFORMATION

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://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

The 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.

Oracle ClientWindows NT or Windows 9xWindows 2000 or Windows XP
7.x [HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\Transaction Server\Local Computer\My Computer] "OracleXaLib"="xa73.dll" "OracleSqlLib"="SQLLib18.dll" "OracleOciLib"="ociw32.dll" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI] "OracleXaLib"="xa73.dll" "OracleSqlLib"="SQLLib18.dll" "OracleOciLib"="ociw32.dll"
8.0 [HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\Transaction Server\Local Computer\My Computer] "OracleXaLib"="xa80.dll" "OracleSqlLib"="sqllib80.dll" "OracleOciLib"="oci.dll" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI] "OracleXaLib"="xa80.dll" "OracleSqlLib"="sqllib80.dll" "OracleOciLib"="oci.dll"
8.1 [HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\Transaction Server\Local Computer\My Computer] "OracleXaLib"="oraclient8.dll" "OracleSqlLib"="orasql8.dll" "OracleOciLib"="oci.dll" [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI] "OracleXaLib"="oraclient8.dll" "OracleSqlLib"="orasql8.dll" "OracleOciLib"="oci.dll"


For Microsoft Windows 2000 or Windows XP systems:
  1. Run RegEdit.
  2. Under the following RegKey, edit OracleOciLib, and then set it to the correct values in the previous table: 
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI
    NOTE: If this key has not been added automatically by setup, add "OracleOciLib" to the registry.
For Microsoft Windows NT 4.0 or Microsoft Windows 95 or Windows 98 systems:
  1. Run RegEdit.
  2. Under the following RegKey, edit OracleOciLib and set it to the correct values in the previous table:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer
    NOTE: This key must be added manually using RegEdit.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

239719 INFO: Supportability of the Microsoft ODBC Driver/ OLE DB Provider for Oracle w.r.t Oracle 8.x

244661 FIX: Microsoft Oracle ODBC Driver and Provider Support Connectivity to Oracle 8i

Modification Type:MinorLast Reviewed:8/5/2004
Keywords:kbDatabase kbOracle kbprb kbProvider KB264012 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.