Microsoft KB Archive/837128

= The Oledb32.dll file is not upgraded when you upgrade your operating system from Windows 2000 to Windows Server 2003 =

PSS ID Number: 837128

Article Last Modified on 12/2/2004

-

The information in this article applies to:


 * Microsoft Data Access Components 2.8
 * Microsoft Windows Server 2003, Enterprise Edition

-



SYMPTOMS
When you upgrade the operating system that is running on your computer from Microsoft Windows 2000 to Microsoft Windows Server 2003, you may notice that the incorrect version of the Oledb32.dll file is installed on your computer. If you use this incorrect version of the Oledb32.dll file, you may receive one of the following error messages:

Error message 1

3709 - The connection cannot be used to perform this operation. It is either closed or invalid in this context.

Error message 2

-2147024769 Automation Error

Error message 3

8007007f Unknown Error

Error message 4

8007007f Cannot open the table

Error message 5

&quot;Method'~' of Object '~' failed&quot; on invoking the Open method of an ADODB.Connection

Error message 6

Error: The procedure entry point GetTextExtentPointI could not be located in the dynamic link library MSDART.DLL.

Error message 7

Error connecting to SQL-2147024769-



WORKAROUND
To work around this behavior, extract the compressed Oledb32.dll file from the Windows Server 2003 CD, and then copy the file to the following locations:
 * :\Program Files\common files\system\Ole db
 * %WINDIR%\system32\Dllcache

Note  is a placeholder for the root directory of your computer.

To extract and copy the Oledb32.dll file, follow these steps:  Restart the computer in Safe Mode.  Shut down your computer, and then restart the computer. Before Windows Server 2003 starts to load, press F8. On the Windows Advanced Option menu, use the ARROW keys to select Safe Mode with Networking, and then press ENTER. If you have a dual-boot or multi-boot computer, select the appropriate operating system from the list that appears, and then press ENTER. Click OK when you receive the message that Windows is running in Safe Mode. </li> If Windows is configured to hide protected operating system files, configure Windows Explorer to display operating system files. By default, Windows Explorer hides certain operating system files.  Start Windows Explorer, click Tools, and then click Folder Options.</li> Click the View tab.</li> In the Advanced settings dialog box, click to clear the Hide protected operating system files (Recommended) check box.</li> When you are prompted, click Yes to confirm that you want to display the files, and then click OK.</li></ol> </li> Rename the Oledb32.dll file in the :\Program Files\Common Files\System\Ole DB folder to Oledb32.old. To do this, follow these steps:  In Windows Explorer, locate the following folder:

Right-click Oledb32.dll, click Properties, and then click the Version tab.</li> Verify that the version of the Oledb32.dll file is earlier than 2.80.1022.0.</li> Right-click Oledb32.dll, and then click Rename.</li> Type Oledb32.old, and then press ENTER.</li></ol> </li> Delete the Oledb32.dll file in the %WINDIR% \System32\Dllcache folder if the Oledb32.dll file exists in that folder.  In Windows Explorer, locate the following folder:

%WINDIR% \System32\Dllcache</li> <li>Right-click Oledb32.dll if it exists, and then click Delete.</li> <li>If you are prompted to confirm the deletion, click Yes.</li></ol> </li> <li>Insert the Windows Server 2003 CD into the CD-ROM or DVD-ROM drive of your computer.</li> <li>Extract the Oledb32.dl_ file from the Windows Server 2003 CD, and then copy the file as Oledb32.dll to your hard disk. <ol style="list-style-type: lower-alpha;"> <li>Click Start, click Run, type cmd in the Open box, and then click OK.</li> <li>At the command prompt, type the following lines, and then press ENTER after each line:

cd drive:

cd I386

expand oledb32.dl_ &quot; :\program files\common files\system\ole db\oledb32.dll&quot;

expand oledb32.dl_ %windir%\system32\dllcache\oledb32.dll </li></ol> </li> <li>Register the Oledb32.dll file. <ol style="list-style-type: lower-alpha;"> <li>At the command prompt, type the following lines, and then press ENTER after each line:

drive:

cd &quot; :\program files\common files\system\ole db&quot;

regsvr32 oledb32.dll

</li> <li>When you receive the message that states that the operation was successful, click OK.</li></ol> </li> <li>Remove the Windows Server 2003 CD from the CD-ROM or DVD-ROM drive of the computer.</li> <li>If you want, reconfigure Windows Explorer to hide certain operating system files: <ol style="list-style-type: lower-alpha;"> <li>Start Windows Explorer, click Tools, and then click Folder Options.</li> <li>Click the View tab.</li> <li>In the Advanced settings dialog box, click to select the Hide protected operating system files (Recommended) check box, and then click OK.</li></ol> </li> <li>Restart your computer.</li> <li>Install Microsoft Office SharePoint Portal Server 2003 or Microsoft Windows SharePoint Services.

Note If you still experience the symptoms that are described in the &quot;Symptoms&quot; section after you follow the steps that are described in this article, install MDAC 2.8. For more information about how to obtain MDAC 2.8, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en:

If the version of the Ole32db.dll file is not upgraded to 2.8.1022.0 after you install MDAC 2.8, repeat the steps that are described in this article.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
To determine the version of the Oledb32.dll file, follow these steps:
 * 1) Click Start, click Run, type  :\Program Files\Common Files\System\OLE DB, and then click OK.
 * 2) In the OLE DB folder, right-click oledb32.dll, and then click Properties. The oledb32.dll Properties dialog box appears.
 * 3) Click the Version tab, and then verify the version of the .dll file.

Additional query words: Oledb32.dll; 0x8007007F; -2147024769

<div class="references_section">