URGENT xp_cmsshell asp page and xml

  • Thread starter Thread starter tolgay
  • Start date Start date
T

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
 
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,
 
Back
Top