Hi,

I have written an XML Web Service (VS 2003) that functions properly to return XML queried from the Northwinds database (SQL 2000/SP3). When I try to add an XML Map to a new workbook using the Web Service the attempt fails with a cryptic error message "Cannot load the specified XML or schema source.". Can you tell me the correct syntax for this? I have tried the following:

http://localhost/XcelsiusWebService/XMLDataProvider.asmx/GetCustomers_New

http://localhost/XcelsiusWebService/XMLDataProvider/GetCustomers_New

http://localhost/XcelsiusWebService/XMLDataProvider.asmx?GetCustomers_New

Thanks.

Dave

Hi Dave

Since you don't show us the code you're attempting to use to add the map, you make it very difficult to help you. Plus, this question doesn't concern the VSTO technology, so it's really off-topic here. The first question that comes to my mind, though, is whether the web-service is returning a valid SCHEMA (xsd)? The Add method for XMLMaps requires a schema. From your problem description, it appears GetCustomers_New would return a set of data.