WSE is causing the Excel cannot connect to the SharePoint List error. How do I fix it, while keeping WSE?
Let me apologize if this is not the right forum for this. I wasn't sure where to stick this at.I have a client who is using a 3rd party product that hooks into SharePoint. I'm not really sure what the 3rd party product does, but I do know that it requires and installs Web Service Enhancements (WSE) 2 on the SharePoint server.Initally, this caused the content editor web parts to no longer allow users to use the rich text editors. I was able to set a location in the web.config to remose the soap extension types for the WebPartPages.asmx web service and everything seemed to work.They then realized they could no longer export lists to a spreadsheet. I tried to do the same trick but since that functionality uses OWSSVR.dll (WebDAV) and not a web service, it didn't fix the issue. I removed the WSE entries from the web.config and then I could export to a spreadsheet. So I'm pretty sure WSE is the issue. The resolution in every post I ready said to remove WSE which is not an option here.Below is thecontents of the web.config file.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configuration>
<configSections>
<section name="microsoft.web.services2" type="Microsoft.Web.Services2.Configuration.WebServicesConfiguration, Microsoft.Web.Services2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</configSections>
<system.web>
<webServices>
<protocols>
<remove name="HttpGet" />
<remove name="HttpPost" />
<remove name="HttpPostLocalhost" />
<add name="Documentation" />
</protocols>
<soapExtensionTypes>
<add type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2,Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" priority="1" group="0" />
</soapExtensionTypes>
</webServices>
<customErrors mode="On" />
<httpRuntime maxRequestLength="128000" executionTimeout="900" />
</system.web>
<location path="WebPartPages.asmx">
<system.web>
<webServices>
<soapExtensionTypes>
<remove type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2,Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" priority="1" group="0" />
</soapExtensionTypes>
</webServices>
</system.web>
</location>
<location path="authentication.asmx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>
<location path="wsdisco.aspx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>
<location path="wswsdl.aspx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>
<microsoft.web.services2>
<messaging>
<maxRequestLength>128000</maxRequestLength>
</messaging>
</microsoft.web.services2>
</configuration>
Any ideas?- John
December 3rd, 2009 11:01pm
Try the following:
<location path="_vti_bin">
<system.web>
<webServices>
<soapExtensionTypes>
<remove type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2,Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" priority="1" group="0" />
</soapExtensionTypes>
</webServices>
</system.web>
</location>
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2010 11:03am