Hi

I would expect to see an image from the database with that code:

<%
set conn=server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.jet.OLEDB.4.0"
conn.Open "F:/projet/test1.mdb"

set rs= conn.Execute("SELECT photo FROM photos where ID=1")

Response.ContentType="image/jpg"
Response.BinaryWrite(rs("photo"))

conn.Close
%>

or

with dsn(data source name) link in contral panel
<%

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "WinConnection"

set rs= conn.Execute("SELECT photo FROM photos where ID=1")

Response.ContentType="image/jpg"
Response.BinaryWrite(rs("photo"))

conn.Close
%>

The only thing I get is a tons of ascii code
Anyone can help me on this ?

I get another problem

When Im doing a refresh 3 or 4 times on that asp page there is a messagebox with prompts as follows:
==================================
Title: File Download - Security Warning
Name: Setup.exe
From: localhost

Buttons: [Run] [Save] [Cancel]

While files from internet can be useful, this file type can potentially harm your computer. If you do not trust the source, do not run or save this software. (link: ) What's the risk?
================================


When i copy paste the code in a new asp file
it works like 3 or 4 times (doing some refresh) and then the messagebox come back

I tried to change security level for intranet too, but i don't know which parameter to change.

I tried with Firefox and Opera and the same problem happens.

thanx
Chris