Home > Archive > Microsoft SQL Server forum > April 2006 > Download image datatype to Jpegs or GIF's









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 Download image datatype to Jpegs or GIF's
mcgrathml@gmail.com

2006-04-04, 7:35 am

Hi,

I want download photos (image datatype) from a SQL-2000 database
into windows based jpeg files (one for each record). Just wondering is
there any way of doing this without using TEXTCOPY?

Michael

Maury

2006-04-04, 7:35 am

mcgrathml@gmail.com ha scritto:
> Hi,
>
> I want download photos (image datatype) from a SQL-2000 database
> into windows based jpeg files (one for each record). Just wondering is
> there any way of doing this without using TEXTCOPY?
>
> Michael
>

You can write a simple .net program to read/write
images (as byte streams) on a BLOB field
of a SQL Server (or Access) database.

If you are interested I can post you the
(small and simple) code...

Bye
M.A.
Sponsored Links





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

Copyright 2008 droptable.com