Posted by herman404 on 10/24/06 16: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?wdsl

But 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>

• Next in forum: Help with an update query
• Prev in forum: Re: Enterprise Manager takes 10+ min to open
• Thread view: How to form URL for browser Endpoint access?

[Reply to this message]