Hide download URL

As we could see in many web site. while we tried to download the file, we would not be able to see the original URL, but just the file name. I tried to some thing similar like this. I have got some sample code here.

set rs=server.CreateObject("ADODB.RecordSet")
rs.open "select file from downfile where downid="&request("id")&" and downno="&request("no"),conn,1,1
 if not rs.eof then
  fileurl = rs("file")
 else
  rs.close
  set rs=nothing
  conn.close
  set conn=nothing
  response.write error
  response.end
 end if
 rs.close
 rs.open "select hits,hy from down where id="&request("id"),conn,1,2
 if not rs.eof then
  hy=rs("hy")
  rs("hits")=rs("hits")+1
  rs.update
 else
  rs.close
  set rs=nothing
  conn.close
  set conn=nothing
  response.write error
  response.end
 end if
 rs.close
 response.redirect fileurl

As you have seen, the page will redirect to fileurl, which is the URL address contained in the database. I have visited the site which use this code and it works as I mentioned above, but dosen't work on my site. Is this a correct code or I should use some thing else? Thanks

Thanks fernan82, but I couldn't find your previous message. would you mind to post it again. I realy appreciate it. thanks. The problem find for the code above is the same as you said: user will be redirect to the new address and they would be able to see the URL.

<%
Option Explicit

Dim objStream
Dim strFilename

strFilename = "/downloads/filename.zip"
strFilename = Server.MapPath(strFilename) 'Comment this if using physical path

Set objStream = Server.CreateObject("ADODB.Stream") 'Create stream object

objStream.Type = 1   'Set it to binary
objStream.Open     'Open It
objStream.loadFromFile(strFilename) 'Read the file

Response.ContentType = "application/unknown"   'Set content type
Response.addHeader "content-disposition", "attachment;filename=" & Chr(34) & strFilename & Chr(34) 'Send header

Response.BinaryWrite objStream.Read 'Send file

objStream.Close 'Close object
Set objStream = Nothing   'Relase it
%>

Edited by fernan82