URGENT xp_cmsshell asp page and xml

[tolgay]

Hi,

I would like to call an asp page in sql ( probably with xp_cmshell) and read
xml response ( from the asp page returns xml format) and update a table.
Would you give an example for this.

Thanks

 

[Kent Tegels]

Hello tolgay,

What version of SQL Server are you using and are you calling a SOAP Web Service.

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/

 

[Warren Brunk]

If you are using SQL 2000 you should be using the SQL Server 2000 webservice
toolkit located here...
http://www.microsoft.com/downloads/...2b-6390-4260-b208-2058c0bfd7de&displaylang=en

SQLXML 3.0 extends the built-in XML capabilities of SQL Server 2000 with
technology to create XML Web services from SQL Server stored procedures or
server-side XML templates. SQLXML 3.0 also includes extensions to the .NET
Framework that provide SQLXML programmability to the languages supported by
Microsoft® Visual Studio® .NET, including C# and Microsoft Visual Basic®
..NET.


If you are using SQL 2005 calling webservices is natively supported. Here is
a nice books online article...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/soapscenarios.asp

thanks,