I am trying to use SQLXML to expose a stored procedure as a webservice.The SQL server has SQLXML 3.0 SP2 installed, and is running SQL Server 2000 sp4. As a proof of concept I am attempting to implement a tutorial I found on msdn: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/creatingawebservice.aspI have followed the instructions, and am trying to execute the vb script from within an asp page, however the page simply hangs on the xmlhttp.send (request) command and the progress bar will just creep up indefinately slowly but never return an error or a result.I have set up a virtual directory which points to a dir on the server called "SQLXMLa", which I did using Virtual Directory management for SQLXML 3.Within this I set up a virtual name "temp1" to interface with a stored procedure in the northwind database, and specified the ISAPI.dll as:"C:\Program Files\Common Files\System\Ole DB\sqlis3.dll"The dialog accepted the settings with no errors.The only other thing worth mentioning is that the server has a number of websites configured to run off differing IP's, but all on the same server. Initially the wsdl file generated referenced the hostname of the server, so I tried changing this to the correct IP for the website, but this made no difference.Finally I enclose the code from the asp file that is making the request below.Any help much appreciated!Cheers, Roy-Svork<% Dim xmlhttp set xmlhttp = CreateObject("Msxml2.XMLHTTP.4.0") Dim request request = "<?xml version='1.0' encoding='UTF-8' standalone='no'?>" & _ "<SOAP-ENV:Envelope xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/'>" & _ " <SOAP-ENV:Body>" & _ " <OrdersForCustomer xmlns='http://192.168.2.57/SQLXMLa/temp1'>" & _ " <CID>BOTTM</CID>" & _ " </OrdersForCustomer>" & _ " </SOAP-ENV:Body>" & _ "</SOAP-ENV:Envelope>" xmlhttp.open "POST", "http://192.168.2.57/SQLXMLa/temp1", False xmlhttp.send (request) 'response.write xmlhttp.responseXML.xml response.write "done" %>
exposing stored procedures as web services
Posted - 2005-11-29 : 12:00:50
