For Programmers: Free Programming Magazines  


Home > Archive > ASP > March 2004 > Re: Images in databases









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Images in databases
Andy B

2004-03-28, 9:55 pm

"Dave" <dave@nospamweip.org> wrote in message news:<btip2j$6j3@dispatch.concentric.net>...
> I have an Access database with a few OLE embedded images. I can get them to
> display in a report, and from a query, but I can't get them to display on an
> .ASP page.
>
> Anyone have a clue?
>
> Here's the site that doesn't work, if that'd be helpful
>
> www.churchgrowth.net/asptest/store.asp
>
> Thanks,
>
> Dave


Take a look at this thread
http://groups.google.com/groups?hl=...0yahoo.co.uk%2B

I wouldn't use Access database to store images. Use MSDE - it's sql
server and its free. I then used the scripts here:
http://www.pscode.com/vb/scripts/Sh...61&lngWId=4#zip
to view the images, and upload the images too.

Without looking at your code, it sounds like you're missing some sort
of bitstream conversion. If it's only a few images - do you really
need them in a database?
Dave

2004-03-28, 9:55 pm

Actually.... There's only a few images in there at first to get it to work.
It's real concept is to be the front end of a store (the back end is in
place with a different front end already). I'm using Access since the load
will not be large. I have been looking at other solutions like MySQL, and
I'll probably give a look at MSDE while I'm in the middle of this.

Since my post, I found

http://support.microsoft.com:80/sup...&NoWebContent=1

that is what I'm looking for, though I haven't had success with it yet.

And yes, what I was missing was the (in the link above) Response.BinaryWrite

Thanks for your rely..

Dave


"Andy B" <coastalrocket@yahoo.co.uk> wrote in message
news:f1523bf.0401150714.44e8b13a@posting.google.com...
> "Dave" <dave@nospamweip.org> wrote in message

news:<btip2j$6j3@dispatch.concentric.net>...
them to[color=darkred]
on an[color=darkred]
>
> Take a look at this thread
>

http://groups.google.com/groups?hl=...0yahoo.co.uk%2B
>
> I wouldn't use Access database to store images. Use MSDE - it's sql
> server and its free. I then used the scripts here:
> http://www.pscode.com/vb/scripts/Sh...61&lngWId=4#zip
> to view the images, and upload the images too.
>
> Without looking at your code, it sounds like you're missing some sort
> of bitstream conversion. If it's only a few images - do you really
> need them in a database?



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com