Access2003+SOAP+XML

[stehy]

Hello,
I'm from Slovakia ( me english is poor, sorry ).

Me problem is:
I have to comunication from access database with web service. I have to send with SOAP "XML file" and I have to wait for reply. Is concerned about order.
I use some code about it.

Thank.
Stehy

I have access 2003 also Web Service References Tool and SOAP Toolkit.

[MMcCarthy]

Hello,
I'm from Slovakia ( me english is poor, sorry ).

Me problem is:
I have to comunication from access database with web service. I have to send with SOAP "XML file" and I have to wait for reply. Is concerned about order.
I use some code about it.

Thank.
Stehy

I have access 2003 also Web Service References Tool and SOAP Toolkit.

I am moving this to the XML forum as I don't think its an Access problem.

[Dököll]

Hello,
I'm from Slovakia ( me english is poor, sorry ).

Me problem is:
I have to comunication from access database with web service. I have to send with SOAP "XML file" and I have to wait for reply. Is concerned about order.
I use some code about it.

Thank.
Stehy

I have access 2003 also Web Service References Tool and SOAP Toolkit.

Greetings, stehy!

Your English is fine, keep it up:-)

Will take a look at a simple option and will let you know. Take a look here while you wait:
http://www.w3schools.com/soap/default.asp

Welcome to the scripts!

[Dököll]

Greetings, stehy!

Your English is fine, keep it up:-)

Will take a look at a simple option and will let you know. Take a look here while you wait:
http://www.w3schools.com/soap/default.asp

Welcome to the scripts!

Did a little reading...

I think I found what you needed:

http://www.w3schools.com/soap/soap_httpbinding.asp

Please write if you need more help.

[stehy]

Thank you for your answer.
( I didn’t know me question was moved from access forum to xml forum )

I have this code in Access:

Dim soapclient
Set soapclient = New SoapClient30
soapclient.ClientProperty("ServerHTTPRequest") = False ‘..when = True I have error, I don’t know why
Call soapclient.MSSoapInit2("https://www.xxxx.asmx?wsdl", "", "Service", "ServiceSoap", "http://tempuri.org/")
soapclient.ConnectorProperty("ProxyServer") = "<CURRENT_USER>"
soapclient.ConnectorProperty("EnableAutoProxy") = True
soapclient.ConnectorProperty("ProxyUser") = "userName"
soapclient.ConnectorProperty("ProxyPassword") = "userPassword"
soapclient.ConnectorProperty("Timeout") = 90000


'This is me order I want to send to Web service:

Dim strxml As String
Dim wsm_ADCBased_AOS As MSXML2.IXMLDOMNodeList
strXml = "<?xml version="1.0" encoding="iso-8859-2" ?>
- <Packet> - <Order Version="1" Test="TRUE" ClientUDZS="" ClientCode="1303" " _ClientICO="" ClientDIC="" DistributorCode="AAA" DistributorUDZS="" DistributorICO="" DistributorDIC="" OrderNumber="92343_A0001" CreateDate="20070330" RequiredDeliveryDate="20070330" RowCount="10" PackageCount="15" DeliveryPlaceCode="001" Type="0" TargetTransferCode="" TargetTransferICO="" TargetTransferDIC="" TargetTransferEmail="">
- <ProductList>
<Product ADCCode="" SUKL="" VDSLCode="" EANCode="" Quantity="12" Unit="KS" ProductName="A" />
<Product ADCCode="" SUKL="" VDSLCode="" EANCode="" Quantity="5" Unit="KS" ProductName="B" />
<Product ADCCode="" SUKL="" VDSLCode="" EANCode="" Quantity="10" Unit="KS" ProductName="C" />
</ProductList>
</Order>
</Packet>"

Set wsm_ADCBased_AOS = soapclient.ADCBased_AOS(strxml) ‘…ADCBased_AOS is one from two metod on Web service where I connected

When I send it reply me error 5050
What is wrong? ( Sorry, I'm only laicus ).

Thank, Stehy