URGENT xp_cmsshell asp page and xml

10 Oct 2006 8:23 AM

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

10 Oct 2006 10:39 AM

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/

10 Oct 2006 5:58 PM

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/details.aspx?familyid=ca1cc72b-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,

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

Show quote

"tolgay" <t***@tgul.com> wrote in message
news:%23C5Q%23XE7GHA.3732@TK2MSFTNGP05.phx.gbl...
> 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
>
>