Assertion: SQL Server 2000 can't issue a SOAP call -- sql server (alternate)

robhindman NO[at]SPAM hotmail.com
3/21/2004 10:17:45 PM

I really hope I'm wrong about this - I can't find any way to issue a
SOAP call from SQL Server 2000. I've looked at the BOL, Google, MSDN,
and the SQLXML documentation and samples...

There is quite a bit of discussion about how to EXPOSE SQL Server 2000
as a SOAP service, or even exposing stored procedures as web service
calls.

But I can find absolutely NO mention of calling a separate SOAP
service from SQL Server 2000, and therefore I would like to assert to
this group that it can't be done - with the hope of finding out with
certainty...

For example, I have the following wsdl target:
http://mssoapinterop.org/stk/Interop.wsdl, and I would like to call
the Interop/SoapPort/echoString method. (It takes any string for the
inputString parameter, and just echoes it back.)

I'd love to do this from a stored procedure, or from an extended
stored procedure, but I don't think that it can be done AT ALL - which
makes me curious - if SQL Server 2000 with SQLXML can expose
functionality as SOAP methods, surely it would be possible to issue a
SOAP call as well?

Many Thanks to anyone who can confim this assertion or show it to be
false.

Steve Jorgensen
3/22/2004 9:03:53 AM

If you can create a COM object to do it, you can use the COM object from
T-SQL, right?

[quoted text, click to view]

robhindman NO[at]SPAM hotmail.com
3/24/2004 7:10:24 PM

[quoted text, click to view]

Hi Steve, Yes, using the sp_OAxxxx family of stored procedure calls
allowed me to call the SOAP Toolkit version 3.0 objects directly from
T-SQL, and collect the results of the SOAP call as needed. I have
several generic examples now - if anyone would like to see them, I can
post them or email them. (I'm not really sure if anyone is interested,
especially since Microsoft wants to withdraw support for the Soap

hifchan NO[at]SPAM yahoo.com
4/2/2004 9:01:18 AM

Yes, I'd like to see the examples posted here.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (alternate)

sql server (alternate) : Assertion: SQL Server 2000 can't issue a SOAP call