OleDB does not work on upgraded Win2003 machines
We've encountered this error for some of our applications and this morning I encountered it when trying to install FogBUGZ and getting a "Database is down" (or something like that) message.
After much troubleshooting and trial-and-error, we ran across a newsgroup posting [ http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&selm=e6Xxl18SEHA.2504%40TK2MSFTNGP09.phx.gbl&rnum=3 ] pointing to an article [ http://myitforum.techtarget.com/articles/18/view.asp?id=7298 ] that solved the problem.
Long story short, when MDAC 2.8 is installed on a machine that had Windows 2003 installed as an upgrade (from say, Windows 2000), the OleDb32.dll file has the wrong version (it should be 2.80.1022.0 - we had 2.71.9042.0), so rename the DLL currently in "c:\program files\common files\system\ole db\" to .bak and copy the right oledb32.dll in its place. (you can get the right oledb32.dll from a machine that had a clean Win2k3 install on it or apparently from the MDAC package)
Monday, August 9, 2004
Fog Creek Home