Can someone help me find an example that queries a db and return data to the
caller. Below is what I'v been able to put together from this list buy my
CFMX is returning an error.
WebMethod(MessageName:="Hello"), _
SoapDocumentMethod( _
RequestElementName:="CheckOrderParameter", _
ResponseElementName:="CheckOrderResponse")> _
Public Function HelloWorld() As XmlDataDocument
Dim conn As SqlConnection = New
SqlConnection("xxx\xxxx;uid=xx;pwd=xx;database=xx" )
Dim cmd As SqlCommand = New SqlCommand("usp_GetNihFudingForYear",
conn)
cmd.CommandType = CommandType.StoredProcedure
Dim da As SqlDataAdapter = New SqlDataAdapter
Try
conn.Open()
Catch ex As Exception
End Try
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds)
conn.Close()
Dim result As XmlDataDocument = New XmlDataDocument(ds)
Return result
End Function
-------------------------------------
CFMX ERROR
Could not perform web service invocation "HelloWorld" because AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Client faultSubcode:
faultString: Server did not recognize the value of HTTP Header SOAPAction:
http://tempuri.org/SVC_WebService/Service1/HelloWorld. faultActor: faultNode:
fau...