J
johanWMU
Trying to set up a connection between a web service and infopath according to
a microsoft training example:
http://msdn.microsoft.com/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_09.asp?frame=true&_r=1
The webservice function looks like this:
Public Function ReceiveDataSet() As DataSet
Dim dstDataSet As New DataSet()
Dim conPubs As SqlConnection
Dim dadAdapter As SqlDataAdapter
conPubs = New SqlConnection("[ed]")
dadAdapter = New SqlDataAdapter("select * from intranet_users where
username like '%j%'", conPubs)
dadAdapter.Fill(dstDataSet, "intranetUsers")
'conPubs.Close() '?
Return dstDataSet
End Function
The webservice seems to work when accessing it from a browser. However, when
trying to connect to it from the infoPath data connection wizard I get a
error that states that I have a "undeclared XSD element:
'{http//www.w3.org/2001/XMLSchema}schema'".
Would really appreciate if anybody could give some feedback on this.
Best Regards
Johan
a microsoft training example:
http://msdn.microsoft.com/library/en-us/odc_ip2003_tr/html/odc_INF_Lab_09.asp?frame=true&_r=1
The webservice function looks like this:
Public Function ReceiveDataSet() As DataSet
Dim dstDataSet As New DataSet()
Dim conPubs As SqlConnection
Dim dadAdapter As SqlDataAdapter
conPubs = New SqlConnection("[ed]")
dadAdapter = New SqlDataAdapter("select * from intranet_users where
username like '%j%'", conPubs)
dadAdapter.Fill(dstDataSet, "intranetUsers")
'conPubs.Close() '?
Return dstDataSet
End Function
The webservice seems to work when accessing it from a browser. However, when
trying to connect to it from the infoPath data connection wizard I get a
error that states that I have a "undeclared XSD element:
'{http//www.w3.org/2001/XMLSchema}schema'".
Would really appreciate if anybody could give some feedback on this.
Best Regards
Johan