Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
herman404
Starting Member
10 Posts |
 Posted - 2006-10-24 : 12:49:47
|
| Hi everyone,I have a stored procedure that outputs an transformed XHTML document as an XML data type. I have an HTTP Endpoint that exposes this procedure. What I want to know is how do I form the URL to access this XHTML document directly. I have granted connect access to public and I have tried this URL:http://servername/EndpointPath?wdslBut all I get in return is the following SOAP message at the end of this post. Does anyone know if it is possible to directly access the HTTP Endpoint's response by a browser, or am I going to have to write a special client to consume it?Thanks,--------------------------------------------------------------------- <?xml version="1.0" encoding="utf-8" ?> - <SOAP-ENV:Envelope xml:space="preserve" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://www.w3.org/2003/05/soap-envelope" xmlns:sql="http://schemas.microsoft.com/sqlserver/2004/SOAP" xmlns:sqlsoaptypes="http://schemas.microsoft.com/sqlserver/2004/SOAP/types" xmlns:sqlrowcount="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlRowCount" xmlns:sqlmessage="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlMessage" xmlns:sqlresultstream="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlResultStream" xmlns:sqltransaction="http://schemas.microsoft.com/sqlserver/2004/SOAP/types/SqlTransaction" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:wsdlgen="http://schemas.microsoft.com/sqlserver/2004/SOAP">- <SOAP-ENV:Body>- <SOAP-ENV:Fault xmlns:sqlsoapfaultcode="http://schemas.microsoft.com/sqlserver/2004/SOAP/SqlSoapFaultCode">- <SOAP-ENV:Code> <SOAP-ENV:Value>SOAP-ENV:Receiver</SOAP-ENV:Value> - <SOAP-ENV:Subcode> <SOAP-ENV:Value>sqlsoapfaultcode:UnknownSqlServerError</SOAP-ENV:Value> </SOAP-ENV:Subcode> </SOAP-ENV:Code>- <SOAP-ENV:Reason> <SOAP-ENV:Text xml:lang="en-US">A server error occurred while processing SOAP request: Receiver, UnknownSqlServerError</SOAP-ENV:Text> </SOAP-ENV:Reason> <SOAP-ENV:Node>http://vdm44sql1:80/VegaRisk?wdsl?VegaRiskSVG</SOAP-ENV:Node> <SOAP-ENV:Role>http://schemas.microsoft.com/sqlserver/2004/SOAP</SOAP-ENV:Role> - <SOAP-ENV:Detail>- <sqlresultstream:SqlMessage xsi:type="sqlmessage:SqlMessage"> <sqlmessage:Class>16</sqlmessage:Class> <sqlmessage:LineNumber>25</sqlmessage:LineNumber> <sqlmessage:Message>An unexpected query string was passed to a Web Service Description Language (WSDL) generation procedure.</sqlmessage:Message> <sqlmessage:Number>17885</sqlmessage:Number> <sqlmessage:Procedure>sp_http_generate_wsdl_defaultcomplexorsimple</sqlmessage:Procedure> <sqlmessage:Server>VDM44SQL1</sqlmessage:Server> <sqlmessage:Source>Microsoft-SQL/9.0</sqlmessage:Source> <sqlmessage:State>1</sqlmessage:State> </sqlresultstream:SqlMessage> </SOAP-ENV:Detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-24 : 13:56:09
|
| You cannot access an endpoint with a browser (other than to get the WSDL, which is what you saw). Endpoints only support SOAP, not GET or POST requests, which is what a web browser sends, so yes, you will have to create a web service (SOAP) client. |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-10-24 : 15:39:59
|
| Could you higlight the actual data passed in the message,maybe there is a more efficient way...rockmoose |
|
|
|
|
|
|
How to access HTTP Endpoint via a URL?