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.Clie ntProperty("Ser verHTTPRequest" ) = False ‘..when = True I have error, I don’t know why
Call soapclient.MSSo apInit2("https://www.xxxx.asmx?w sdl", "", "Service", "ServiceSoa p", "http://tempuri.org/")
soapclient.Conn ectorProperty(" ProxyServer") = "<CURRENT_USER> "
soapclient.Conn ectorProperty(" EnableAutoProxy ") = True
soapclient.Conn ectorProperty(" ProxyUser") = "userName"
soapclient.Conn ectorProperty(" ProxyPassword") = "userPasswo rd"
soapclient.Conn ectorProperty(" Timeout") = 90000


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

Dim strxml As String
Dim wsm_ADCBased_AO S As MSXML2.IXMLDOMN odeList
strXml = "<?xml version="1.0" encoding="iso-8859-2" ?>
- <Packet> - <Order Version="1" Test="TRUE" ClientUDZS="" ClientCode="130 3" " _ClientICO="" ClientDIC="" DistributorCode ="AAA" DistributorUDZS ="" DistributorICO= "" DistributorDIC= "" OrderNumber="92 343_A0001" CreateDate="200 70330" RequiredDeliver yDate="20070330 " RowCount="10" PackageCount="1 5" DeliveryPlaceCo de="001" Type="0" TargetTransferC ode="" TargetTransferI CO="" TargetTransferD IC="" TargetTransferE mail="">
- <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_AO S = soapclient.ADCB ased_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