ASP & ADODB Stream - Permission denied (0x80040E09) / Error Hell
Software Engineer
and trying to read a publicly accessibly web page from ASP code.
----------------------------------------
<%
Set stmDB = Server.CreateObject("ADODB.Stream")
stmDB.Charset = "ascii"
stmDB.Open "URL=http://w3.myserver.com/default.htm", 1, -1
Response.Write stmDB.ReadText
stmDB.Close
Set stmDB = Nothing
' The same code works fine in VB6 running the same server as ASP code
%>
----------------------------------------
Initially the code gave me a '80004005' error when I make the 'stmDB.Open'
call.
Later I installed VB6 and ran the same code in VB6 - with no problems.
(What did VB6 install to fix the '80004005'? Doesn't MDAC 2.5
installed with Win2K have all I need to run this code?)
Then I went back to ASP and re-ran the code; now I get a access denied
error.
Does anyone have a clue as to what is going on.
Just for the hell of it, I tried passing UserName/Password
with the stmDB.Open call but that just gave a different error [Provider
(0x80004005) Unspecified error]
It looks like permissions problem but what permissions do I need to change?
P.S. There was a time when error messages told you what the problem
was and where, or at the very least you got a different error number for
different problems. MS please fix this error hell.