Aspupload Response.Binary Retrieve Image Datatype

Found that the code offered by aspupload to retrieve image datatype needs to be altered to work with MS SQL whereas it works fine with MS Access.

The following piece of code has the BinaryWrite executing prior to the ContentType request:

<%
' AspUpload Code samples: filelist_download.asp
' Invoked by filelist.asp
' Copyright (c) 2001 Persits Software, Inc.
' http://www.persits.com

' The file must not contain any HTML tags, not even HTML comment tags <!-- ...-->

' Build ADO connection string
Connect = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(".aspupload.mdb")

' If you use SQL Server, the connecton string must look something like this:
' Connect = "Provider=SQLOLEDB;Server=MYSRV;Database=master;UID=sa;PWD=xxx"

Set db = Server.CreateObject("ADODB.Connection")
db.Open Connect

SQL = "SELECT * FROM MYIMAGES where id = " & Request("id")
Set rs = db.Execute( SQL )
If rs.EOF Then Response.End

' Send actual file
Response.BinaryWrite rs("image_blob")

Response.ContentType = "application/octet-stream"

' Let the browser know the file name
Response.AddHeader "Content-Disposition", "attachment;filename=" & Trim(rs("filename"))

' Let the browser know the file size
Response.AddHeader "Content-Length", CStr(rs("filesize"))


%>