February 26, 2004 at 6:49 am
Hi,
Does anyone know if I can initiate a SOAP RPC request directly from an SQL stored procedure using SQLXML?
Thanks,
Neil.
March 1, 2004 at 8:00 am
This was removed by the editor as SPAM
March 1, 2004 at 10:48 am
I doubt it since SQL Server can not actually issue SQLXML requests to other servers. SQLXML is an API for applications to access SQL Server (Sort of like ADO, OLE DB, etc.) and not for SQL Server to initiate external connections.
That's my best guess.
[font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
Business Intelligence Administrator
MSBI Administration Blog
March 16, 2004 at 8:34 am
OK, let's generalize the question: Does anyone know of a way to generate requests to (and consume responses from) web services via T_SQL, DTS, etc.?
R David Francis
March 16, 2004 at 9:39 am
The focus of SQL Server 2000 Web Release 3 (SQLXML 3.0) is Web services. (You can download SQLXML 3.0 at http://www.microsoft.com/downloads/details.aspx?familyid=4023deea-f179-45de-b41d-84e4ff655a3b&displaylang=en.) SQLXML 3.0 lets you select stored procedures from your database and XML templates from your virtual directory to expose as a Web service's methods. Microsoft also supplies a toolkit for SQLXML 3.0 (http://www.microsoft.com/downloads/details.aspx?familyid=ca1cc72b-6390-4260-b208-2058c0bfd7de&displaylang=en)
yes you can consume web services from T-SQL. See http://www.winnetmag.com/SQLServer/Article/ArticleID/16202/16202.html for a description of this.
Francis
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply