• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Consuming and Providing XML ... > Providing SQLXML Web Services

Providing SQLXML Web Services

Visual Basic 6.0 programmers can use the Microsoft SOAP Toolkit 3.0+ to generate SOAP wrappers and WSDL files for ActiveX components. Visual Studio .NET 1.0+ automates the process for creating ASP.NET XML Web services. Access 2003 developers have only one option for delivering data with Web services—SQL Server 2000 stored procedures delivered from virtual directories you create with Microsoft’s SQLXML 3.0+ Web release.

The first two versions of SQLXML extended SQL Server/MSDE 2000’s built-in XML feature set with additional XML capabilities, such as updategrams and support for XSD schemas in addition to Microsoft’s original (and proprietary) XML Data Reduced (XDR) annotated schemas. SQLXML 3.0 adds the Web service feature, which automates the process of exposing stored procedures as document/literal Web services. The following sections describe how to install SQLXML, and create and test a simple Web service from NorthwindSQL’s Sales by Year stored procedure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint