sql server - Classic ASP download file from sql return 0 byte -
sql server - Classic ASP download file from sql return 0 byte -
i'm having problems when download files bigger 5mb (until 10mb limit me).
i got 0 byte file. it's file empty, btw, file uploaded correctly on db. checked using tsql datalength()
this code:
<% response.buffer = false ssql = "select name, filestore files id=" & request("idfile") set ors = server.createobject("adodb.recordset") ors.open ssql, application("myconn") if not ors.eof response.addheader "content-disposition", "filename=""" & ors("name") & """" response.contenttype = "application/unknown" response.binarywrite ors("filestore") response.end end if ors.close set ors = nil %>
any idea???
thanks answers guys. found problem. on iis related asp buffer limit. increasing setting worked fine.
sql-server asp-classic download adodb
Comments
Post a Comment