The Oledb32.dll file is not upgraded when you upgrade your operating system
from Windows 2000 to Windows Server 2003
Article ID : 837128
Last Review : December 2, 2004
Revision : 1.0
On this page
SYMPTOMS
WORKAROUND
MORE INFORMATION
REFERENCES
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
"Method'~' of Object '~' failed" 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: * <System Drive>:\Program Files\common files\system\Ole db
* %WINDIR%\system32\Dllcache
Note <System Drive> is a placeholder for the root directory of your computer.
To extract and copy the Oledb32.dll file, follow these steps: 1. Restart the
computer in Safe Mode. a. Shut down your computer, and then restart the
computer.
b. Before Windows Server 2003 starts to load, press F8.
c. On the Windows Advanced Option menu, use the ARROW keys to select Safe
Mode with Networking, and then press ENTER.
d. If you have a dual-boot or multi-boot computer, select the appropriate
operating system from the list that appears, and then press ENTER.
e. Click OK when you receive the message that Windows is running in Safe
Mode.
2. 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. a. Start Windows
Explorer, click Tools, and then click Folder Options.
b. Click the View tab.
c. In the Advanced settings dialog box, click to clear the Hide protected
operating system files (Recommended) check box.
d. When you are prompted, click Yes to confirm that you want to display the
files, and then click OK.
3. Rename the Oledb32.dll file in the <System Drive>:\Program Files\Common
Files\System\Ole DB folder to Oledb32.old. To do this, follow these steps: a.
In Windows Explorer, locate the following folder:
<System Drive>:\Program Files\Common Files\System\Ole DB
b. Right-click Oledb32.dll, click Properties, and then click the Version
tab.
c. Verify that the version of the Oledb32.dll file is earlier than
2.80.1022.0.
d. Right-click Oledb32.dll, and then click Rename.
e. Type Oledb32.old, and then press ENTER.
4. Delete the Oledb32.dll file in the %WINDIR% \System32\Dllcache folder if
the Oledb32.dll file exists in that folder. a. In Windows Explorer, locate
the following folder:
%WINDIR% \System32\Dllcache
b. Right-click Oledb32.dll if it exists, and then click Delete.
c. If you are prompted to confirm the deletion, click Yes.
5. Insert the Windows Server 2003 CD into the CD-ROM or DVD-ROM drive of
your computer.
6. Extract the Oledb32.dl_ file from the Windows Server 2003 CD, and then
copy the file as Oledb32.dll to your hard disk. a. Click Start, click Run,
type cmd in the Open box, and then click OK.
b. At the command prompt, type the following lines, and then press ENTER
after each line:
cd drive:
cd I386
expand oledb32.dl_ "<System Drive>:\program files\common files\system\ole
db\oledb32.dll"
expand oledb32.dl_ %windir%\system32\dllcache\oledb32.dll
7. Register the Oledb32.dll file. a. At the command prompt, type the
following lines, and then press ENTER after each line:
drive:
cd "<System Drive>:\program files\common files\system\ole db"
regsvr32 oledb32.dll
b. When you receive the message that states that the operation was
successful, click OK.
8. Remove the Windows Server 2003 CD from the CD-ROM or DVD-ROM drive of the
computer.
9. If you want, reconfigure Windows Explorer to hide certain operating
system files: a. Start Windows Explorer, click Tools, and then click Folder
Options.
b. Click the View tab.
c. In the Advanced settings dialog box, click to select the Hide protected
operating system files (Recommended) check box, and then click OK.
10. Restart your computer.
11. Install Microsoft Office SharePoint Portal Server 2003 or Microsoft
Windows SharePoint Services.
Note If you still experience the symptoms that are described in the
"Symptoms" 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.
regsvr32 "C:\Program Files\Common Files\System\Ole DB\oledb32.dll"
Thanks.
-TP