I am using VFP6 to call a web service via msSOAP and I am getting an error
returned. The data is being passed to the Web Service and the service is
carrying out it's code. Upon completion the Web service returns the following
error message:
"OLE IDispatch exception code 0 from SoapMapper: SoapMapper: Restoring data
into SoapMapper GetItemResult failed HRESULT=0x80070075. The parameter is
incorrect."
I can get the hello world sample to work fine. My web service is retrieving
data from an AS/400 table and I am trying to read the data in VFP6. I have
read the article below as well as the one titled 'Using Visual FoxPro to call
.Net Web Services for Data Access'. I used VB.net instead of your C# example.
Below is my web method and the function being called. Any suggestions would
be helpful.
<WebMethod()> _
Public Function GetItem(ByVal strItem As String, ByVal strWhse As String,
ByVal strVndr As String) As DataSet
Dim RC As New AS400Connect.InvokeAS400
Return RC.GetItem(strItem, strWhse, strVndr)
RC = Nothing
End Function
Public Function GetItem(ByVal strItem As String, ByVal strWhse As String,
ByVal strVndr As String) As DataSet
Dim SqlString As String
Dim ds As New DataSet
Try
OpenConnections()
SqlString = "SELECT IITEM AS ITEM,IWHSE AS WHSE, IVNDR AS VEND, IDEM13 AS
FORECAST" & _
" FROM E3TIBG.E3ITEMA WHERE IITEM = " + strItem + " and Iwhse = " + strWhse
+ " and ivndr = " + strVndr + " ORDER BY IITEM, IWHSE, IVNDR"
Dim myCommand As New System.Data.Odbc.OdbcCommand(SqlString, conn)
Dim myAdapter As New System.Data.Odbc.OdbcDataAdapter(myCommand)
myAdapter.Fill(ds, "mfUpdates")
GetItem = ds
Catch ex As Exception
End Try
End Function