Can't make Excel Services Client to work

Question

Hi, I'm writing a simple Excel Services client. It's a windows application with a web reference to the sharepoint Excel Services. The reference url is http://<server>/_vti_bin/excelservice.asmx. I instantiate the proxy and try to get a workbook located in a Shared Documets list. But I get the following exception in the client:

 

System.Web.Services.Protocols.SoapException: An error has occurred.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at ExcelScvTest.VMExcelService.ExcelService.OpenWorkbook(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status)

at ExcelScvTest.Form1._btnPrintWeb_Click(Object sender, EventArgs e)

 

And in the server's event log I see the following:

 

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Services Administration
Event ID: 5244
Date:  16/08/2007
Time:  05:40:18 PM
User:  N/A
Computer: SPSTEST
Description:
Excel Services: Unexpected exception while trying to access Shared Services Database;. Error = ExcelServerSharedWebApplication.Local: Could not get ServerContext.Current, which indicates that either SharePoint or the SSP infrastructure isn't provisioned correctly or that we're running outside of a web context..

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any thoughts?

 

Thanks,

 

Sole

Answer 1

It looks like your installation is not working properly.

 

Does EWA work?

 

Also, just to make sure - you are not referencing the Excel Services DLL right? You used the "Add Web References" and put in the URL you gave at the top of your post?

Answer 2

Hi Shaha, thanks for the reply. EWA is working, and used the web reference. Any ideas?

Answer 3

1. Can you please post the code?

2. I also want the subcode of the exception - to get it, output exception.SubCode.Code.Name property. If you havn't done so already, you will need to make sure your proxy works using the Soap12 protocol.

Answer 4

am stuck with the same problem
could u shahar or spano prvide me with any details please????