Back to VSLive! Show Daily Home
Expose SQL Server
Stored Procedures With SQLXML 3.0
SQLXML 3.0 simplifies exposing SQL Server 2000 stored procedures as XML Web Services.
by Jay Schmelzer
VSLive! SF, Day 3, February 14, 2002 — The SQLXML Web releases provide several new features for interacting with a SQL Server 2000 database using XML technologies. SQLXML 3.0 continues to build on these features, adding the ability to expose SQL Server 2000 data using XML-based Web services. SQLXML 3.0 makes exposing SQL Server 2000 stored procedure as XML Web Services easy. And there's more good news: Those Web services are easily consumed by Visual Studio .NET client applications.
Download spsample.zip for a demonstration of how you can expose an existing SQL Server 2000 stored procedure through SOAP, then consume the Web service from a Visual Basic .NET Windows Forms client application.
About the Author
Jay Schmelzer is a partner with Clarity Consulting Inc., an e-business and technology-consulting firm based in Chicago. He actively oversees multiple project teams working on the design, development, and implementation of large-scale systems. In addition, Jay frequently writes articles for technical journals and speaks at IT conferences.
Back to top
|
