Error: The query could not be processed. Errors in the OLE db provider could not connect to the redirector when running a pivot report

When running a pivot report, users may receive the error: The query could not be processed. Errors in the OLE db provider could not connect to the redirector ensure that the SQL browser service is working [file path].


 

If Blackbaud hosts your data:

  1. Run the Pivot Report
  2. Export to Microsoft Office Excel

 

If your data is installed locally, try each of the following steps in order until the issue is resolved:

  1. Unregister the msolap90.dll file and register the msolap80.dll file:
    1. Unregister msolap90.dll, located at C:\Program Files\Common Files\System\Ole DB
    2. Register msolap80.dll, located at C:\Program Files\Common Files\System\Ole DB
  2. Search for and manually register the OWC.DLL and OWC10.DLL files.
  3. Replace the older version of the OWC10.dll file with a newer version
    1. Download version 10.0.6765.0 of the OWC10.dll file from Microsoft's website.
    2. Replace the old OWC10.dll file with the downloaded file.
    3. Manually register the new OWC10.dll file.
  4. Download the Office XP web components from Microsoft.

    For more information, refer to our system requirements for the latest compatibility information.

    Note: The Office XP web components are required for certain Raisers Edge functions to properly operate, regardless of the version of Office installed on the workstation. Review the following TechRepublic article for common uses of the web components: http://articles.techrepublic.com.com/5100-10878_11-1047088.html
  5. Run the Windows and Microsoft Office Online Automatic Updates. For instructions, refer to Microsoft's article: http://support.microsoft.com/kb/306525.
  6. Remove MS Project Service Pack 1 or completely remove MS Project from the workstations experiencing this problem.

Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.

This issue was resolved in 7.91.40.

Download the latest version from our website.

Environment

 7.91.40

Was this article helpful?