How to establish Soap Connection

  • Thread starter Thread starter Thomas Weiler
  • Start date Start date
T

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.
 
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:
 
Michael said:
If your code gets executed at all, Outlook's part is done. For asp.net your
might need to answer in an appropriate newsgroup.
Click to expand...
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.
 
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:
 
Michael said:
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?
Click to expand...
Yes it is called and goes through but I get no action on the webservice.
 
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:
 
Back
Top