Problem connecting OWC11 to Web Service

M

Mark Lutz

I have SPS 2003 Tec. Refresh
OCW11
and have created a simple Web Service that will return a dataset.

When I hit the invoke button in the test section of the Description page it
returns an xml datastream that looks to be correct.

I an trying to connect the OWC11 Office Datasheet to this service. When I
put the URL for the service in using the Connect to an external data source,
(http://server/service/method) it seems to take it with no errors. But does
not display a table at that point. When I hit the page in regular view I get
the following:

Office Datasheet

You do not have permission to connect to a data source defined for this Web
Part. For assistance, contact your site administrator.

I am not sure where else to configure permissions. I have modified the
web.config file as follows

<authentication mode="None" />

<webServices>
<protocols>
<add name="HttpSoap"/>
<add name="HttpPost"/>
<add name="HttpGet"/>
<add name="Documentation"/>
<add name="HttpPostLocalhost"/>
</protocols>
</webServices>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top