When refreshing an Excel Workbook, in Excel Services, using SSO, from an Oracle Database a user receives the error:
"Data Refresh
Unable to retrieve external data for the following connections:
<Connection>
The data sources may be unreachable, may not be responding, or may have denied you access.
Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set."
Environment:
Microsoft Office SharePoint Server 2007 (64 bit)
Oracle Database (64 bit)
Connection String Example:
Provider=OraOLEDB.Oracle.1;Password=#####;Persist Security Info=True;User ID=#####;Data Source=#####;Extended Properties=""
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.