thank you for responding Phillips...
but i need one more clarification..
where does this problem lie... at server or the client from where i am
trying to consume web service.

where do i need to re-install XML SDK on client or on the server running SQL
XML

i appreciate if you could give some way out ....
 
-------Original Message-------
 
From: ASPX_Professional
Date: Wednesday, November 06, 2002 2:36:53 PM
To: ASPX_Professional
Subject: [aspx_professional] RE: SQL XML Web Service Error
 
This could be a problem with XMLA SDK on your machine - try
re-installing it.

http://dbforums.com/t482180.html

Phil

-----Original Message-----
From: Satish [mailto:kvensatish@h...]
Sent: 06 November 2002 08:19
To: ASPX_Professional
Subject: [aspx_professional] SQL XML Web Service Error


i have configured sql server to implement webservice using sqlxml 3.0 sp1.
i have successfully generated proxy class and when i try to call the method
from the proxy class and bind the resultant dataset to a data grid i am
getting the following error...

please any one could explain how i need to go from here

Error Message :

System.InvalidOperationException: Client found response content type of 
text/html', but expected 'text/xml'. The request failed with the error
message: -- HResult: 0x80040154

Source: Microsoft SQL isapi extension
Description: Internal server error occured. Request aborted.
--. at System.Web.Services.Protocols.SoapHttpClientProtocol
ReadResponse(SoapClientMessage message, WebResponse response, Stream
responseStream) at System.Web.Services.Protocols.SoapHttpClientProtocol
Invoke(String methodName, Object[] parameters) at soap
CustOrdersDetail(Int32 OrderID, Int32& returnValue) at ASP.WebService1_aspx
Page_Load(Object sender, EventArgs e) 


thanks
satish

---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces 
for developers who are already familiar with using ASP.NET. 
There is no trivial introductory material or useless .NET 
hype and the presentation of the namespaces, in an easy-to use 
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes, 
giving you those real-world tips that the documentation doesn't 
offer, and demonstrating complex techniques with simple 
examples. 

---

---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces 
for developers who are already familiar with using ASP.NET. 
There is no trivial introductory material or useless .NET 
hype and the presentation of the namespaces, in an easy-to use 
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes, 
giving you those real-world tips that the documentation doesn't 
offer, and demonstrating complex techniques with simple 
examples. 

---