Solved

HTTP Request Problem

Posted on 2013-12-20
9
439 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
  • 4
  • 3
  • 2
9 Comments
 
LVL 19

Expert Comment

by:mrwad99
Comment Utility
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
Comment Utility
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
Comment Utility
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
 

Author Comment

by:ttobin333
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 19

Expert Comment

by:mrwad99
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks!
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now