Downloading Files stored in SQL Server

fibreiv · Feb 10, 2005

I am trying to download files from my database that I uploaded to it. I can
download bmp, txt file but have not been able to d/l pdf files. I am able to
d/l pdf files stored in the file system but not in the database. Any help
would be great. Here is my code, I have hard coded the file to download for
testing purposes.

Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Password=;Initial Catalog=INNB;Data Source=pompom"

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

SQL = "SELECT filesize, contenttype, filename, filedata FROM thefiles where
id = 2"
Set rs = db.Execute( SQL )
If rs.EOF Then Response.End
Response.ContentType = "application/pdf"
Response.AddHeader "Content-Disposition", "attachment;filename=agencies.pdf"
Response.AddHeader "Content-Length", "16863"
Response.BinaryWrite rs("filedata")

Thanks,
Brett Bishop
MCSE, MCP+I
US Bankruptcy Court

larrybud2002 · Feb 10, 2005

fibreiv said:
I am trying to download files from my database that I uploaded to it. I can
download bmp, txt file but have not been able to d/l pdf files. I am able to
d/l pdf files stored in the file system but not in the database. Any help
would be great. Here is my code, I have hard coded the file to download for
testing purposes.

Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Password=;Initial Catalog=INNB;Data Source=pompom"

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

SQL = "SELECT filesize, contenttype, filename, filedata FROM thefiles where
id = 2"
Set rs = db.Execute( SQL )
If rs.EOF Then Response.End
Response.ContentType = "application/pdf"
Response.AddHeader "Content-Disposition", "attachment;filename=agencies.pdf"
Response.AddHeader "Content-Length", "16863"
Response.BinaryWrite rs("filedata")

So what kind of error do you get? How do you know the length is
16863??

When I do my binary retrieves I don't specify the length.

Here's my generic getbinary.asp page... When a file is uploaded I store
the mime type of the file.



<%
ID = Request.QueryString("ID")
tablename=Request.QueryString("tablename")
idfieldname=Request.QueryString("idfieldname")
datafield=Request.QueryString("datafield")
datacon=session("DB_CONNECTIONSTRING")
Set con2 = Server.CreateObject("ADODB.Connection")
Con2.open(datacon)

mysql2="select * from " & tablename &" where "& idfieldname & "=" & ID
Set rs2=con2.execute(mysql2)

if not rs2.EOF then
Response.ContentType = rs2("type_"&right(datafield,
len(datafield)-4))
Response.BinaryWrite(rs2(datafield))
else
Response.Write("Record '" + ID + "' not found.")
end if

rs2.Close
%>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="none, default">
</head>

Downloading files from ASP Page	3	Sep 18, 2006
file size limit for downloading using Response.binarywrite	0	Sep 7, 2008
Downloading a .doc stored in SQL Server from an ASP.net page	9	Mar 26, 2007
Should heavy binary files not be stored in database?	1	Jan 28, 2013
Downloading files	1	Mar 8, 2006
Binary data stored in SQL Server: can't read from ASP.NET, can read from Access?	3	Nov 3, 2005
downloading multiple files	3	Jan 8, 2007
Downloading Large Files	0	Jan 27, 2004

Downloading Files stored in SQL Server

fibreiv

larrybud2002

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads