Download files from SQL failing

I just signed up for a DiscountASP account and the following snippet worked on my old host.

The purpose of the script is to extract binary data from my SQL 08 DB and display a file download dialog to save or open. IE8 is spitting out the generic "IE cannot display the webpage" error.

Code:

<!--#include file="includes/data.asp"-->
<%
If Session("LoginID") <> "" Then
    SQL = "SELECT * FROM dbo.GELeaseFileDocuments where dbo.GELeaseFileDocuments.DocumentID = " & Request.QueryString("id")
    rs.open sql, cn, 3, 1

    Response.ContentType = "application/octet-stream"
    ' let the browser know the file name
    Response.AddHeader "Content-Disposition", "attachment;filename=" & Trim(rs("DocumentName"))
    ' let the browser know the file size
    Response.AddHeader "Content-Length", rs("FileSize")
    Response.BinaryWrite rs("Document")
    rs.close
Else
    Response.write ("Download Failed.")
End If
%>

 

Self-resolved

Resolution: commented out content length.

 

Wow, good job, I would have missed that. ;-)

 

Thanks.

There's no rush like frantic testing and debugging during a migration.