Re: How to download ole objects(MS Access) from ASP?

From: Val Mazur \(MVP\) (group51a_at_hotmail.com)
Date: 03/18/05


Date: Thu, 17 Mar 2005 20:59:45 -0500

Hi,

You need to use GetChunk method of the field or to use Stream object to work
with the BLOB-type fields. These examples could help you

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0102.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;194975

http://support.microsoft.com/default.aspx?scid=kb;en-us;258038

-- 
Val Mazur
Microsoft MVP
http://xport.mvps.org
"shel" <shel@discussions.microsoft.com> wrote in message 
news:10353EEC-8394-4850-95D6-812E26A0E30B@microsoft.com...
> Hi,
>
> I have an Access Database with one of the field's data type as OLE Object.
> The data can be image, MS powerpoint, MS word etc etc.
>
> How can I use ASP to download the file?
>
> I have tried :
> response.contenttype = "application/msword"
> response.binarywrite rs("fieldname")
>
> But when I open the file, it is chunk in it.
> Moreover I have hard coded the content type. How can I know the content 
> type
> too?
>
> The user who input the data did not store contenttype or anything at all.
>
> Thanks 


Relevant Pages

  • Re: Accessing .JPG files from SQL and/or Access
    ... In ADO you could use GetChunk method or ADO Stream object, ... "Mike Searle" wrote in message ...
    (microsoft.public.data.ado)
  • Re: Recordset question
    ... I'm going to give it a shot. ... "Val Mazur" wrote in message ... > this using Stream object. ... > Microsoft MVP ...
    (microsoft.public.vb.database.ado)