Problems retrieving image from SQL server -- inetserver asp db

inetserver asp db : Problems retrieving image from SQL server

Sean
2/20/2006 12:00:00 AM

I need to retrieve a small GIF stored in a SQL server Image field and
display it on an ASP page.

I have a wrapper page to return the image which I call from another page
like this. :

<img src="image_wrap.asp?ProdID=47">

The code to retrieve the image doesn't seem to work, all i get is a default
image place holder and no image. The image is definately in the DB and in
GIF format. I can pull the images just fine in Access. I tried a few
different methods all of which only return an image place holder each time.

Any ideas much appreciated.

image_wrap.asp
===========
<%

Dim iProductID
iProductID = Request.QueryString("ProdID")

Dim objConn, objRS, strSQL
strSQL = "SELECT Image FROM Products WHERE ProdID = " & iProductID

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=dsn3;uid=me;pwd=secret;"

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn

Response.ContentType = "image/gif"
Response.BinaryWrite objRS("Image")

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing

%>

jeff.nospam NO[at]SPAM zina.com
2/20/2006 12:00:00 AM

[quoted text, click to view]

Take a look at:

http://www.aspfaq.com/show.asp?id=2149

Sean
2/20/2006 12:31:01 PM

[quoted text, click to view]

Thanks, I looked at the examples and my modified code is pretty much the
same as http://support.microsoft.com/default.aspx/kb/173308, but still it's
not working. I also tried a couple of the other methods.

The original images were added to SQL server through an Access front end, I
am wondering if Access is adding something weird to the images before
storing them in SQL. The code appears to work, the image is being retreived,
but does not display.

bob
2/23/2006 10:23:06 PM

[quoted text, click to view]

Almost certainly. If you are using OLE Embedding (with a Bound Object Frame, or 'Insert Object', or just
pasting into a field) then the images are stored in the private format of whatever application is registered
to handle that file-type on that system, and further wrapped in headers etc. In fact, even after stripping
the headers there probably isn't a gif image to be found in there.

You can check how the images are stored by opening the table in Access. If the field contents appear as
'Long Binary Data' then you have the gif stored directly in the field, in which case your asp code should
work. If you have anything else (eg Microsoft Photo Editor 3.0 Photo, MS Paint Bitmap etc etc) then you
have OLE Embedded data, with the headers and private format problems that go with that (not to mention
a potentially huge overhead - with JPEG it can be up to 200 *times* the original file size).

--
_______________________________________________________
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about inetserver asp db

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007

home · blog · groups

Questions? Comments? Contact the dn