How to stored procedure exposed as a Web service in SQLXML 3.0

[Mariah-Simpson]

Hi all,

I am a web developer and using asp.net web server. I am already using XML 1.1 .But i did not found any web service. I heard that a SQLXML3.0 provide webservice with stored procedure. Can anybody know that how to stored procedure exposed as a Web service in SQLXML 3.0. Please suggest. Thanks in advance.

[Praetor]

The latest technology is Web services. Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), Universal Description, Discovery and Integration (UDDI) are the basic elements of terms such as XML and the Internet.Web services for building loosely coupled applications and achieving interoperability. Loosely coupled applications that allow you to re-configure, re-deploy or re-positioning its implementation without affecting related applications. Use this and reply.

[Katty]

SQLXML 3.0 focused on Web Services. SQLXML 3.0 enables you to select from a database stored procedure and from the virtual directory, select XML template, exposing them as Web services approach. Because you through Web services and traditional methods such as T-SQL EXEC statement, OLE DB, ADO, and ODBC call the stored procedure, you can maximize re-use these components. To put it simply, SQLXML 3.0 allows you to bring the database programming expertise extends to Web services without the need to learn a new language or tool. Check and reply.

[kelfro]

The stored procedure exposed as a Web service the first step is to install SQLXML 3.0 arising from the Configure IIS Support that configure IIS support menu item, select Microsoft IIS Virtual Directory Manager that is Microsoft IIS Virtual Directory Manager. To create a virtual directory, from the left tree view, select the Web server, and then expand the view and click on the default Web site. Right-click on any region in the right pane and select Context-"New-" Virtual Directory to display a New Virtual Directory Properties tha is New Virtual Directory Properties dialog box. Check and reply if you need more help.

[Zecho]

You need to change the "Security and data source" page, enter the Northwind sample database can access SQL Server login permission. Note that you are "universal" page, select the directory to give you permission to be in the "security and data source" page for the IIS configuration of the default user authorization . In order to avoid licensing problems, the virtual directory for your choice Inetpub \ wwwroot in a subdirectory, IIS default user automatically has access to Inetpub \ wwwroot following permissions to the data. Next, in the "Settings" page, select Allow POST option, so that the virtual directory to accept HTTP POST requests. Click "Apply." Best of luck.

[Reegan]

In order to test the newly created Web service, use the list to display the VBScript code in a. The code to establish a call to the Web service SOAP messages, and then use the XMLHTTP object to the SOAP request sent to the Web service. SOAP results are displayed in a message box. This simple demonstration of the SOAP client care in the VBScript and the exchange between the SQLXML 3.0. However, it also shows the stored procedure call is now available through the HTTP on a cross-platform interoperability using SOAP, WSDL, and SCC by their description of the document provides a loose connection to the stored procedur. Check and reply.