Web Service and the AS400

Question

I'm trying to use a web service that is getting its data from the AS400 and I'm getting this error: 

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Client found response content type of 'text/plain', but expected 'text/xml'. The request failed with the error message: --  <?xml version="1.0" encoding="UTF-8"?><CustomerSearch><Error>Insufficient Search Data</Error></CustomerSearch> --..    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
 
How can I correct this? 

Answer 1

Hi,

Have a read of this thread http://social.msdn.microsoft.com/Forums/en-US/asmxandxml/thread/f8860d82-7b99-49f6-aff2-ce4a30fdb96b/

This person had a similar problem and it turned out that the remote server was refusing the connection request so the Web Service was returning an error instead of a valid response.  The above thread explains how to ascertain what the actual response is that the Web Service is returning.

.NET Webservice Studio 2.0 has been replaced with http://www.codeplex.com/wsstudioexpress

Cheers
Jeff

---

SQL Server MVP / WARDY IT Solutions, Solutions Architect