Why this ASP code all of the sudden stopped working?

Hi,

This classic asp code :

<%
Dim objXMLHTTP
Set objXMLHTTP = Server.CreateObject("microsoft.XMLHTTP")
objXMLHTTP.Open "GET",
"http://finance.yahoo.com/d/quotes.csv?s=ABX+ABX.TO&f=sl1d1t1c1ohgv&e=.csv",
False
objXMLHTTP.Send
Response.write objXMLHTTP.ResponseText
%>

Returns the follwoing error:

msxml3.dll error '80070005'
Access is denied.
/tsx/sg.ASP, line 8

Is there any way I can fix that?

Any help would be appreciated,
Max

McKirahan
Thu Oct 04 19:22:45 PDT 2007

"Max2006" <alanalan1@newsgroup.nospam> wrote in message
news:OMf87KvBIHA.1408@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> This classic asp code :
>
> <%
> Dim objXMLHTTP
> Set objXMLHTTP = Server.CreateObject("microsoft.XMLHTTP")
> objXMLHTTP.Open "GET",
>
"http://finance.yahoo.com/d/quotes.csv?s=ABX+ABX.TO&f=sl1d1t1c1ohgv&e=.csv",
> False
> objXMLHTTP.Send
> Response.write objXMLHTTP.ResponseText
> %>
>
> Returns the follwoing error:
>
> msxml3.dll error '80070005'
> Access is denied.
> /tsx/sg.ASP, line 8
>
> Is there any way I can fix that?

I cut-and-pasted the URL into a browser and got the error:

Internet Explorer was not able to open this Internet site.
The requested is either unavailable or cannot be found.
Please try again later.

You may want to use On Error Resume Next
and check for errors.

stcheng
Thu Oct 04 21:29:31 PDT 2007

Hi Max,

I've also tried the url, seems when I try open the csv file, it report
error indicate that the file is not available.

Anyway, I suggest you test your code against some server documents(maybe on
your local server) that are ensured to work. thus, you can may sure it is
not your scritp code that cause the problem. Mostly it is possibly that
ther server document has something incorrect.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "McKirahan" <News@McKirahan.com>
>Newsgroups: microsoft.public.inetserver.asp.general
>References: <OMf87KvBIHA.1408@TK2MSFTNGP05.phx.gbl>
>Subject: Re: Why this ASP code all of the sudden stopped working?
>Date: Thu, 4 Oct 2007 21:26:30 -0500

>
>"Max2006" <alanalan1@newsgroup.nospam> wrote in message
>news:OMf87KvBIHA.1408@TK2MSFTNGP05.phx.gbl...
>> Hi,
>>
>> This classic asp code :
>>
>> <%
>> Dim objXMLHTTP
>> Set objXMLHTTP = Server.CreateObject("microsoft.XMLHTTP")
>> objXMLHTTP.Open "GET",
>>
>"http://finance.yahoo.com/d/quotes.csv?s=ABX+ABX.TO&f=sl1d1t1c1ohgv&e=.csv"
,
>> False
>> objXMLHTTP.Send
>> Response.write objXMLHTTP.ResponseText
>> %>
>>
>> Returns the follwoing error:
>>
>> msxml3.dll error '80070005'
>> Access is denied.
>> /tsx/sg.ASP, line 8
>>
>> Is there any way I can fix that?
>
>I cut-and-pasted the URL into a browser and got the error:
>
> Internet Explorer was not able to open this Internet site.
> The requested is either unavailable or cannot be found.
> Please try again later.
>
>You may want to use On Error Resume Next
>and check for errors.
>
>
>

Anthony
Fri Oct 05 01:05:18 PDT 2007

"Max2006" <alanalan1@newsgroup.nospam> wrote in message
news:OMf87KvBIHA.1408@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> This classic asp code :
>
> <%
> Dim objXMLHTTP
> Set objXMLHTTP = Server.CreateObject("microsoft.XMLHTTP")
> objXMLHTTP.Open "GET",
>
"http://finance.yahoo.com/d/quotes.csv?s=ABX+ABX.TO&f=sl1d1t1c1ohgv&e=.csv",
> False
> objXMLHTTP.Send
> Response.write objXMLHTTP.ResponseText
> %>
>
> Returns the follwoing error:
>
> msxml3.dll error '80070005'
> Access is denied.
> /tsx/sg.ASP, line 8
>
> Is there any way I can fix that?
>

Apart from the fact that the URL you've provided doesn't appear to be
accessible anyway. You should use "MSXML2.ServerXMLHTTP.3.0" or (since
you're not actually getting XML) "WinHttp.WinHttpRequest.5.1".



--
Anthony Jones - MVP ASP/ASP.NET

jp2code
Fri Oct 05 06:31:39 PDT 2007

Sup Max?

Looks like it is working today.

Maybe Yahoo!'s site was down at the time for maintenance. You could ask
them, but by the time they answered you, we'd both have forgotten what the
question was!

BTW: That's a neat way of grabbing stock quotes! I like it. Do you have more
to show? :)

"Max2006" asks:
> Hi,
>
> This classic asp code :
>
> <%
> Dim objXMLHTTP
> Set objXMLHTTP = Server.CreateObject("microsoft.XMLHTTP")
> objXMLHTTP.Open "GET",
> "http://finance.yahoo.com/d/quotes.csv?s=ABX+ABX.TO&f=sl1d1t1c1ohgv&e=.csv",
> False
> objXMLHTTP.Send
> Response.write objXMLHTTP.ResponseText
> %>
>
> Returns the follwoing error:
>
> msxml3.dll error '80070005'
> Access is denied.
> /tsx/sg.ASP, line 8
>
> Is there any way I can fix that?
>
> Any help would be appreciated,
> Max
>
>