FIX: Handle Leak in ODBC Driver/OLE DB Provider

• Microsoft ODBC for Oracle (Build 2.573.2927), version 2.5
• Microsoft OLE DB Provider for Oracle, version 2.0

SYMPTOMS

Both the Oracle ODBC Driver, version 2.573.2927, and the Oracle OLE DB Provider, version 2.0.3002.15, shipping with the Microsoft Data Access Components (MDAC) version 2.0 have handle leaks, which lead to memory leaks. MDAC version 2.0 components are included both in the Data Access 2.0 Software Development Kit (SDK) as well as Visual Studio version 6.0.

CAUSE

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

RESOLUTION

The Oracle ODBC Driver, version 2.573.2927, and the Oracle OLE DB Provider, version 2.0.3002.15, were both fixed with the release of the MDAC version 2.1 components. Please install MDAC version 2.1 if you are experiencing the handle leak. If you cannot upgrade to MDAC version 2.1 you can still install the ODBC Driver fix mentioned in this article. You must upgrade to MDAC version 2.1 if you are using the OLE DB Provider for Oracle.

The fix contains a patched version of the Microsoft Oracle ODBC Driver. At this time, it does not contain a patched version of the Oracle OLE DB Provider.

A supported fix that corrects this problem is now available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem. If you are not severely affected by this specific problem, Microsoft recommends that you wait for the next service pack that contains this fix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information on support costs, please go to the following address on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp

   Date        Time        Version        Size    File name    Platform
   --------------------------------------------------------------------
   09-25-1998 12:41:42 PM  2.573.3002.24  138,512 msorcl32.dll Windows 

Installation Instructions

1. Extract the files into a new directory.



2. Locate the Msorcl32.dll file on your computer.



3. Copy the new .dll files (created by unzipping the files) to the Windows system directory.



4. Register the .dll files using Regsvr32.exe (provided with the patch) using the following syntax:
   

   regsvr32 dll name.dll

   
   You also need to register the Msorcl32.dll file.



5. Reboot the system.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words: oracle memory leak

Keywords : kbDatabase kbDriver kbODBC kbOLEDB kbOracle kbProvider kbGrpVCDB kbGrpMDAC kbMDAC200 kbMDAC210fix
Version : WINDOWS:2.0,2.5
Platform : WINDOWS
Issue type : kbbug