Ask a questionAsk a question
 

AnswerCan't make Excel Services Client to work

  • Thursday, August 16, 2007 8:46 PMspano Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    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

Answers

  • Friday, August 17, 2007 6:45 PMShahar Prish - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer

    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.

All Replies

  • Friday, August 17, 2007 7:33 AMShahar Prish - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    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?

  • Friday, August 17, 2007 2:36 PMspano Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

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

  • Friday, August 17, 2007 6:45 PMShahar Prish - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer

    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.

  • Sunday, October 25, 2009 3:29 PMmms2000 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    am stuck with the same problem
    could u shahar or spano prvide me with any details please????