Solved

HTTP Request Problem

Posted on 2013-12-20
9
447 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
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
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

809 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