Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message in Excel Services 2010 when you refresh a workbook that uses an .odc file as a data connection: "An error has occurred."

Error message in Excel Services 2010 when you refresh a workbook that uses an .odc file as a data connection: "An error has occurred."

View products that this article applies to.

Symptoms

Consider the following scenario:
  • You have a computer that is running Microsoft Excel Services 2010.
  • You refresh a workbook that uses an .odc file as a data connection.
In this scenario, you receive the following error message:
An error has occurred.

↑ Back to the top

Cause

This problem occurs when the .odc file is hand-edited and contains special non-escaped characters.

↑ Back to the top

Resolution

To resolve this problem, correctly escape any special characters in the file according to XML rules. Any special characters must be XML-escaped. The hand-edited portion should be in the <CommandText> element as escaped XML characters.

↑ Back to the top

Keywords: KB981292, kbprb, kbsurveynew, kbtshoot, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 981292
Revision : 4
Created on : 9/18/2011
Published on : 9/18/2011
Exists online : False
Views : 249