Strange problem with displaying images from database

[rolandschwarz2001]

Hi people !

We have encountered a strange problem and have no idea where this comes.
description : we are developing a webshop, and in the productlisting we use an asp-script to load and display product images.
script is this one :

<!--#INCLUDE FILE=&quot;shop.asp&quot; -->
<!--#INCLUDE FILE=&quot;DBConnOpen.asp&quot; -->
<%
Dim rsImage
Dim ContentType
sql = &quot;SELECT Extension, Bin FROM Artikelbin WHERE Artikelnummer='&quot; & Request.Querystring(&quot;ArtNr&quot & &quot;' AND Nummer=&quot; & Request.QueryString(&quot;BNr&quot
Set rsImage = conn.execute(sql)
if rsImage.EOF then
Response.Status = &quot;204 No Content&quot;
else
Select Case UCase(rsImage(&quot;Extension&quot)
Case &quot;JPG&quot;
ContentType = &quot;image/jpeg&quot;
Case Else
ContentType = &quot;image/&quot; & rsImage(&quot;Extension&quot
End Select
Response.ContentType = ContentType
Response.BinaryWrite(rsImage(&quot;Bin&quot)
end if
%>
<!--#INCLUDE FILE=&quot;DBCOnnClose.asp&quot; -->

Until yesterday this worked.
and that very fine.
Now the aspfile display no images.
and we just have no idea why.
the content is the same, no changes.no codechanges.the environment is as follows:

webserver ms iis version 5 with frontpage server extensions 2002
development tool : ms visual interdev ver.6 , 9064- .
The database server is a mssqlserver, version 7.
The datatype in the corresponding db-field is image.

Ie 5.5 as browser, but netscape 6.1 makes no difference.
restarting the webserver and/or entire computer makes no difference.

a colleague said, he encountered the same problem some time ago.
what he did to solve is somehow *braindead*.
he copied the project in interdev to a new project and continued working in the new project where everything was fine.

Has anyone any idea about this stupid sh.... ?


thanks alot to everyone and have a nice weekend !

greetings

roland