HTTPEndPoint - XML SOAP

The easiest way I can tell you to do this is use Visual Studio .NET 2005 and
create a web reference to the endpoint.

For example if your endpoint is /sql, then first use Internet Explorer and
verify you can read the WSDL, like so:

http://mysqlserver/sql?wsdl

Once you get this working, then you can point Visual Studio .NET 2005 Web
Service wizard to this URL and it will create a web service proxy class for
you.

For more details see this article:

http://msdn2.microsoft.com/en-us/lib...2(SQL.90).aspx

You then use this proxy class to call the web service, like below:

private void soapIntegrated()
{
soapclient.endpoint soapClient = new soapclient.endpoint();
soapClient.Url = "http://mysql/clear_integrated";
soapClient.Credentials = System.Net.CredentialCache.DefaultCredentials;

soapClient.Timeout = 5000;

// Do the work.
int x1, x2, result;
for(int i=1; i<=loopCount; i++)
{
try
{
x1 = tid;
x2 = i;
result = (int)soapClient.multiply(x1, x2);
if (result != (x1*x2))
{
log("result != (x1*x2) -> result=" + result + " x1=" + x1 + " x2=" +
x2);
}
}
catch (Exception ex)
{
log("Failure on multiply(" + tid + "," + i + ")");
logex(ex);
}
}
}

"Joriveek" wrote:

> Hi,
>
> I have successfully created and run the HTTPEndpoint stored procedure,
>
> how do I run/call the stored procedure with SOAP RPC/WSDL on the client's
> machine?
>
> the HTTPEndPoint storedprocedure is register on the network/webservices
>
> Thanks
> J.
>
>
>