We have recently started receiving an error when we do an “Any Word” search for words such as "personal care". These are not noise word.
Here is the error message.
Based on my initial investigation it seems like this message is generated from the database server and being relayed to the user by the TRIM workgroup server.
We contacted the HP TRIM helpdesk and they mentioned this error generally appears when the MDAC is corrupted.
Their recommendations were to:
1. Reregister the OLE32.DLL
2. Repair MDAC - you can get the latest version for www.microsoft.com
3. Reinstall MDAC
4. Reinstall TRIM
5. Reinstall the Operating System
6. Reimage the computer
When I mentioned the time constraints, they recommended trying a Wild Card search. Example: personal* care
Wow, actually that worked and I thought it will be useful to share this tip.
At this stage I’m not exactly sure how it fixes the issue, but I’m assuming the SQL query passed to the database might be the difference. I’m planning to run SQL Profiler to see the difference. I’ll share my experience when it is completed.
No comments:
Post a Comment