Hi. I'm stumped.

Im getting an 'Unspecified error' on the line marked in red (see code below) on the server Microsoft 2000 Service Pack 4(IIS5, IE6) where on the server Microsoft 2000 Service Pack 2(IIS5, IE6) executes no problems.

Any ideas?

<%
var adModeRead = 1;
//
var adOpenStreamUnspecified = -1;
//
var adTypeBinary = 1;
var path = "http://servername/virtualpathtoddoc/docname.ext";
        try {
            var objStream = Server.CreateObject("ADODB.Stream");
            //This is where the error is invoked
objStream.Open("URL=" + path, adModeRead, adOpenStreamUnspecified);
            objStream.Type = adTypeBinary;
            Response.Write(objStream.Size);
        } catch(e) {
            Response.Write(e.description + " " + e);
        } finally {
            objStream.Close();
            objStream = null;
            Response.End;
        }
%>

The server it doesn't work on has MDAC 2.8 SP1 and the server it works on has MDAC 2.7. It also seems to be an undocumented bug with MDAC 2.8 (i.e. no patches or hotfixes available).

I'm gonna try downgrading to 2.7 - hope it works.

Ok downgrading didn't work (for whatever reason). Beware once u upgrade your MDAC there's pretty much no going back.

I did however find a work around (see code below)

<%
 var strFilePath = "http://servername/virualpath_to_another_machine/pathtodoc/docname.ext";
 var remote = Server.CreateObject("Msxml2.ServerXMLHTTP.4.0");
 remote.open("GET", strFilePath, false);
 remote.send();
 Response.BinaryWrite(remote.responseBody);
 Response.End;
%>
If you want the size, I did it this way

<%
 var remote = Server.CreateObject("Msxml2.ServerXMLHTTP.4.0");
 remote.open("GET", strFilePath, false);
 remote.send();
 var Stream = Server.CreateObject("ADODB.Stream");
 Stream.Open();
 Stream.Type = 1 ;// adTypeBinary = 1
 Stream.Write(remote.responseBody);
 Stream.Position = 0;
 lngBytes = Stream.Size;
 s = (lngBytes / 1024);//.length;
 s = s.toFixed(0);
%>

Dont forget to close the stream and the remote and set them to null.

Hope this helps.:)