When you upgrade from Windows 2000 to Windows Server 2003, the Oledb32.dll is NOT updated. Using this previous version may result in any of the following errors:
3709 - The connection cannot be used to perform this operation. It is either closed or invalid in this context.
-2147024769 Automation Error
8007007f Unknown Error
8007007f Cannot open the table
"Method'~' of Object '~' failed" on invoking the Open method of an ADODB.Connection
Error: The procedure entry point GetTextExtentPointI could not be located in the dynamic link library MSDART.DLL.
Error connecting to SQL-2147024769-
NOTE: See Microsoft Knowledge Base article 837128 for the steps necessary to extract the compressed Oledb32.dll file from the Windows Server 2003 CD, and copy the file to:
%SystemDrive%\Program Files\common files\system\Ole db
%SystemRoot%\system32\Dllcache