• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

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

0
kneidels
Asked:
kneidels
  • 2
  • 2
1 Solution
 
neeraj523Commented:
Hello

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..
0
 
kneidelsAuthor Commented:
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
0
 
neeraj523Commented:
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..
0
 
kneidelsAuthor Commented:
ok, thanks Neeraj!
0

Featured Post

Independent Software Vendors: 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!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now