How to establish Soap Connection

[Thomas Weiler]

Hello,

Iam trying to connect to a ASP.NET Webservice on another Server via
Outlook 2003 VBA. I´ve linked the "Microsoft Soap Type Library".

When I now go through the following code via debugger, it goes without
any error message. But on the Webserver nothing happens (Ived activate
the debugger on the ASP.NET Application and nothing happens).

What do I make wrong or what is missing in the code to establish a
correct connection?

-------------------------- snip ----------------------------------

Dim msxml As New MSXML2.XMLHTTP


strEnvelope = _
"<soap:envelope
xmlns:soap=""urn:schemas-xmlsoap-org:soap.v1"">" & _
"<soap:header></soap:header>" & _
"<soap:body>" & _
"<myFunction xmlns='http://tempuri.org/'>" & _
"<var1>TextTextText</var1>" & _
"<var2>string</var2>" & _
"</myFunction>" & _
"</soap:body>" & _
"</soap:envelope>"



strServ = "http://myserver/myservice.asmx"

msxml.Open "post", strServ, False
msxml.setRequestHeader "Content-Type", "text/xml"

msxml.Send strEnvelope

-------------------------- snap ----------------------------------

Thanks for all answers.

 

[Michael Bauer [MVP - Outlook]]

If your code gets executed at all, Outlook's part is done. For asp.net your
might need to answer in an appropriate newsgroup.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 16 Jul 2009 15:05:24 +0200 schrieb Thomas Weiler:

 

[Thomas Weiler]

If your code gets executed at all, Outlook's part is done. For asp.net your
might need to answer in an appropriate newsgroup.

Thats the problem. The Webserver with the asp.net Webservice don`t get
any data (there is no entry in the web server log too). It seems that
the vba code goes through without doing anything.

 

[Michael Bauer [MVP - Outlook]]

Have you tried to set a breakpoint (f9) at the line:

msxml.Open "post", strServ, False

and seen whether or not the line is called?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 20 Jul 2009 07:54:56 +0200 schrieb Thomas Weiler:

 

[Thomas Weiler]

Have you tried to set a breakpoint (f9) at the line:

msxml.Open "post", strServ, False

and seen whether or not the line is called?

Yes it is called and goes through but I get no action on the webservice.

 

[Michael Bauer [MVP - Outlook]]

Ok, that's what I thought. You need someone who can help with either the xml
library or asp/your webserver. In an appropriate newsgroup the chance for a
helpful answer should be better.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 21 Jul 2009 15:22:26 +0200 schrieb Thomas Weiler: