error in web service reporting

hi friends i created a web service for reporting service. When i try
to send the parameter i am getting error of "here is an error in the
query. Failed to execute web request for the specified URL." I am
pasting the web method and the xml query can u please help me out in
this i am new to this field.
<WebMethod()> _
Public Function GetUserID(ByVal User_ID As Integer) As DataSet2
Dim ta As New
DataSet2TableAdapters.core_ApplicationUserTableAdapter()
Dim ds As New DataSet2
Dim dt As New DataSet2.core_ApplicationUserDataTable
ta.ClearBeforeFill = True
ta.FillByUSerID(dt, User_ID)
ds.Merge(dt)
Return ds
End Function
<Query>
<Method Namespace="http://tempuri.org/" Name="GetUserID"/>
<SoapAction>http://tempuri.org/GetUSerID
</SoapAction>
<Parameters>
<Parameter Name="User_ID">
<Value>User_ID</Value>
</Parameter>
</Parameters>
<ElementPath IgnoreNamespaces="true">
GetUSerIDResponse{}/
GetUSerIDResult/diffgram{}/DataSet2/core_ApplicationUser
</ElementPath>
</Query>
Please help me outHi
The easiest way to resolve this issue is to use an HTTP tracer like
fiddler. As a starting point try creating a parameterless web method
and querying against that just to verify that you are hitting the end
point. If that works , the next step would be to check the element
path . I would look at the query being sent by using fiddler and then
compare it to the wsdl definition to see if the web service is getting
all its parameters in the format it expects. This article pertains to
using ssrs to query a MOSS webservice but should help you out.
http://rockstarguys.com/blogs/colin/archive/2006/11/10/accessing-sharepoint-list-items-with-sql-server-2005-reporting-services.aspx
Cheers
Shai
On Nov 19, 4:05 pm, ayrookuzhy <arujgeo...@.gmail.com> wrote:
> hi friends i created a web service for reporting service. When i try
> to send the parameter i am getting error of "here is an error in the
> query. Failed to execute web request for the specified URL." I am
> pasting the web method and the xml query can u please help me out in
> this i am new to this field.
> <WebMethod()> _
> Public Function GetUserID(ByVal User_ID As Integer) As DataSet2
> Dim ta As New
> DataSet2TableAdapters.core_ApplicationUserTableAdapter()
> Dim ds As New DataSet2
> Dim dt As New DataSet2.core_ApplicationUserDataTable
> ta.ClearBeforeFill = True
> ta.FillByUSerID(dt, User_ID)
> ds.Merge(dt)
> Return ds
> End Function
> <Query>
> <Method Namespace="http://tempuri.org/" Name="GetUserID"/>
> <SoapAction>http://tempuri.org/GetUSerID
> </SoapAction>
> <Parameters>
> <Parameter Name="User_ID">
> <Value>User_ID</Value>
> </Parameter>
> </Parameters>
> <ElementPath IgnoreNamespaces="true">
> GetUSerIDResponse{}/
> GetUSerIDResult/diffgram{}/DataSet2/core_ApplicationUser
> </ElementPath>
> </Query>
> Please help me out|||Tks buddy
Cheers
Aruj