error with MSXML

Posted on 2009-04-21
Last Modified: 2012-08-13
hi there

i have a script that runs thru a database and bills customers via gateway, using MSXML.
it works fine... execpt that after 5 or 6 successfully charged rows, it throws an error:

msxml3.dll error '800c0005'
The system cannot locate the resource specified.

the line number points to the line below, with the stars.

when i refresh the page, the script continues to run fine- for another 5 or 6 rows till it gets stuck again.

anyone know why this could be?

Dim oXMLHttp


	Set oXMLHttp=Server.CreateObject("MSXML2.XMLHTTP")	'MSXML2.XMLHTTP "get", "" & str,false


	oXMLHttp.send     '******** ERROR IS ON THIS LINE 


	GetTranzillaResponse = oXMLHttp.responseText

	Set oXMLHttp = Nothing

Open in new window

Question by:kneidels
    LVL 22

    Accepted Solution


    This error comes because at some point of time, your web server wasnt able to communicate with the remote server for data processing. The reason of this may be internet instabllity if you are running script at a local server, or network issue because of what a specific location become inaccesxsable at some point of time..

    The work around is, capture this exception and retry to those rows till you dont get success response.

    hope it will help..

    Author Comment

    Thanks neeraj.

    the server is our own dedicated one, so i would assume its stable. the fact that the error is constant , every 5 or 6 rows, not matter what time of day etc - also seems to indicate a deeper issue.

    are you saying to do 'on error resume next' ?

    LVL 22

    Expert Comment

    see.. here the question is not the only stability of server, there are lot of other reasons like network issue at server, routing path/DNS issues, connectivity issue at target server etc..

    yes, resume next is the one way to handle this issue provided by skipping request which generated error will be executed at next itration..

    Author Comment

    ok, thanks Neeraj!

    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

    Introduction HyperText Transfer Protocol ( or "HTTP" is the underpinning of internet communication.  As a teacher of web development I have heard many questions, mostly from my younger students who have come to t…
    The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API ( has made its way into the popular lexicon of the English language.  A few years ago, …
    This video teaches users how to migrate an existing Wordpress website to a new domain.
    The viewer will learn how to dynamically set the form action using jQuery.

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now