Link to home
Start Free TrialLog in
Avatar of kneidels
kneidels

asked on

error with MSXML

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?

Thanks!
does
Dim oXMLHttp
	
	Set oXMLHttp=Server.CreateObject("MSXML2.XMLHTTP")	'MSXML2.XMLHTTP
	oXMLHttp.open "get", "https://secure5.tranzila.com/cgi-bin/tranzila39.cgi?" & str,false
		
	oXMLHttp.send     '******** ERROR IS ON THIS LINE 
	
	GetTranzillaResponse = oXMLHttp.responseText
	Set oXMLHttp = Nothing

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of neeraj523
neeraj523
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kneidels
kneidels

ASKER

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' ?

thanks
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..
ok, thanks Neeraj!