Solved

HTTP Request Problem

Posted on 2013-12-20
9
449 Views
Last Modified: 2016-02-26
Dear Experts,

I am having problems with an HTTP request within my VB6 application.  It works perfectly when running the code in the VB6 development environment but not from the compiled EXE file.

When running the EXE, I am getting error -2146697211 at the objHTTP.send strEnvelope command.

The identical call works from within another similar app without problems, making me wonder if some kind of reset command is required.

The code is below.

Thanks for your help!

///////////////////////////////////////////////

Dim objHTTP As New MSXML2.XMLHTTP
Dim strEnvelope As String
Dim strReturn As String
Dim objReturn As New MSXML2.DOMDocument
Dim nodeReturned As IXMLDOMNode
Dim xStatus As String

'load xml file to be posted to the server
strEnvelope = https://www.xyz.com/jsp/validateKey.jsp?...

objHTTP.Open "get", strEnvelope, False

'Make the SOAP call
objHTTP.send strEnvelope

'Load the return envelope into a DOM
objReturn.Load objHTTP.responseBody

'Query the return envelope
Set nodeReturned = objReturn.selectSingleNode("//status")

xStatus = nodeReturned.Text
0
Comment
Question by:ttobin333
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
9 Comments
 
LVL 19

Expert Comment

by:mrwad99
ID: 39734927
The error number -2146697211 means that the server or proxy server you are trying to connect to cannot be found.  Is it possible that your hosts file is incorrect somehow?
0
 

Author Comment

by:ttobin333
ID: 39735050
As stated, the call works perfectly when running from within Visual Basic so the connection information is correct.
0
 
LVL 19

Expert Comment

by:mrwad99
ID: 39735665
Yes, I read that :)

Running the app from within the IDE is not the same as running the bare exe, because it is possible that the IDE may be elevating the exe, hence it has permission to read the hosts file.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:ttobin333
ID: 39737250
After a reboot, it started working again but I need this to be as reliable as possible. What can I do to make it more robust?
0
 
LVL 19

Expert Comment

by:mrwad99
ID: 39738013
What was the result of running the app as administrator?  Also, have you tried running it on a completely clean machine (say, a virtual one)?
0
 
LVL 3

Accepted Solution

by:
CvD earned 500 total points
ID: 39740839
From what I read it looks like your memory is "dirty". Meaning, the reference as addressed by objHTTP still lingers, because you do not close it properly. The connection is gone, but the pointer exists. Rebooting gives you a clean memory sleet, therefor it works again.

Destroy the object by nullifying it (i.e. objHTTP = null (or Nothing i don't know what you need in this case))
0
 

Author Comment

by:ttobin333
ID: 39744326
Thank you for the responses.

CvD, this sounds like a good idea. Will try it as soon as I can make the error occur again.

Mrwad99, running as administrator did not solve the problem.

Thanks.
0
 
LVL 3

Expert Comment

by:CvD
ID: 39744570
You should alway cleanup unless you are absolutely certain the programming language will do a proper job cleaning up. In case of any doubt as to this matter, cleanup before you proceed. I.e. nullify objHTTP and objReturn wheather you get the error or not.
0
 

Author Closing Comment

by:ttobin333
ID: 39760691
Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question