Hi Reader,
I have created a WS which receives and returns XML. The WS works on my IIS6 Web server but not on my Abyss 2.8 X" Web server.
The WS comprises of:-
[WebMethod]
//<?xml version="1.0" encoding="UTF-8"?><traceabilityRequest><authenticationCode>xxxxxx</authenticationCode><vPlusCode>051301100013ECC</vPlusCode></traceabilityRequest>
public XmlDocument traceabilityRequest(string XMLtraceabilityRequest)
{
string[] arryTraceabilityRequest = new string[2];
XmlDocument docRequest = new XmlDocument();
docRequest.LoadXml(XMLtraceabilityRequest);
XmlNodeList nlTR = docRequest.SelectNodes("traceabilityRequest");
XmlNode root = nlTR[0];
int i = 0;
foreach (XmlNode node in root.ChildNodes)
{
string name = node.Name;
string value = node.InnerText;
arryTraceabilityRequest
= name + "|" + value;
i++;
}
string[] vPlusCode = arryTraceabilityRequest[1].Split(new Char[] { '|' });
clsSQL ClsSQL = new clsSQL();
return(ClsSQL.GetTraceabilityResponse(vPlusCode[1]));
}
and my dataset class consists of:-
public XmlDocument GetTraceabilityResponse(string vPlusCode)
{
OpenConn();
SqlCommand cmd = new SqlCommand("dbo.MyStyleTraceabilityResponse", SqlCon);
cmd.Parameters.AddWithValue("@MyStyleCode", vPlusCode);
cmd.CommandType = CommandType.StoredProcedure;
XmlDocument XMLDoc = new XmlDocument();
using (XmlReader XMLRdr = cmd.ExecuteXmlReader())
{
if (XMLRdr.Read())
{
string strXML = XMLRdr.ReadOuterXml();
XMLDoc.LoadXml(strXML);
}
}
return (XMLDoc);
}
SQL Server is generating the data with a "FOR XML" output. As I say works in IIS not Abyss. Any ideas?