[thelist] MS Access to SQL Server: METAFILE Images

Rory.Plaire at wahchang.com Rory.Plaire at wahchang.com
Wed Sep 26 18:39:13 CDT 2001


|     Does anyone have a guess (preferably an educated one :) 
| as to how I can
| extract and display the content of these images from SQL Server?


Well,

I'm not educated herein. 

But I know it is a pain and somewhat inefficient to go storin' a bunch 'o
images in SQL Server... the filesystem is much more efficient here.

So...

P'raps you could extract the images to a directory and include, instead, a
link to the files in the SQL2K DB. Then, on a Response.Write, you could
stream a "<img href=""" & RS.filepath && "">" or something similar.

Not exactly what you were looking for, I know. But I'm out of your box, and,
as much as I sympathize with how impossible it is to break out sometimes
(even due to factors beyond our control), it can't hurt to look in from the
outside... usually. ;)

<rory disposition="out of one box... into one higher" alt="8}"/>




More information about the thelist mailing list