Problem
DeskLot Error at Location 59, Error Code 2147221164 - Class not registered.
Solution
1/14/2005: We are currently working on a solution to this newly presented problem. The solution provided below is not yet proven and is currently being attempted on Windows XP operating systems.
1/14/2005:
When some users apply Microsoft Windows Updates, Windows Update is not updating the OleDB32.dll with the new version required for Microsoft Data Access Components (MDAC) 2.8. DeskLot is effected by this as DeskLot uses the "Microsoft.Jet.OLEDB.4.0" driver to connect to the DeskLot databases.
This problem first began occurring with "some" users 1/2005 as a result of Microsofts latest updates. In case Microsoft comes up with a fix for this problem, we suggest visiting http://windowsupdate.microsoft.com/ and updating your computer with all critical updates and then seeing if the problem is resolved PRIOR to continuing with the instructions in this document.
When users attempt to run MDAC_TYP.exe to update their MDAC 2.8 (which should fix the problem), Windows notifies them that "MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows."
To repair the problem, follow the instructions below:
Ssearch your computer via "Start", "Search" and then "For Files or Folders".
Under "What do you want to search for?", select "All files and folders"
In the "All or part of the filename:" box, enter OleDB32.dll and then click search.
You should (normally) at least find the file located in the c:\Program Files\Common Files\System\Ole DB\ folder.
On some systems it might also be found in c:\YOUR WINDOWS FOLDER\System32\DllCache\.
Once it is found, right click on the file(s) and select properties.
Click the Version tab.
The version SHOULD be (both occurences of the file if both locations are found) at least 2.80.1022.0 (the version running on our development machine and available for download is 2.81.117.0).
If the file version number for the Oledb32.dll files is 2.71.9042.0 or earlier, first rename (rename function available by right-clicking the file in Windows Explorer) them to a different filename in case we need to revert back to the original versions for any reason. Then download and save the 2.81.117.0 or greater version of Oledb32.dll into the folder(s). You may download the file at http://www.desklot.com/downloads/OleDB/OleDB32.dll
Please keep us posted on this situation and what resolved it. If this article does not solve the problem, please contact us.
Keywords
59, 2147221164, Class not registered, Windows Update, Service Pack