Okay, all I'm trying to do is call an asp page for the source of an image, and I can't get it to work on any three of my servers... any help with what I'm messing up would be greatly appreciated

<!-- Begin source of page1.asp -->

<table width="160 height="120" cellpadding="0" cellspacing="0" border="0">
 <tr>
  <td width="160" height="120">
   <img src="page2.asp?ID=1" border="0">
  </td>
 </tr>
</table>

<!-- End source of page1.asp -->

<!-- Begin source of page2.asp -->

<%
strID = Request.Form("ID") 
strAccessDB = "Pics.mdb"
strConnect = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strAccessDB)
Set ObjConn = Server.CreateObject ("ADODB.Connection")
objConn.Open strConnect
Set objRec = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblImages.* From tblImages WHERE fldID=" & strID & ";"
objRec.Open strSQL, strConnect, 2, 3
strSRC = objRec("fldSRC")
Response.Write(strSRC)
%>

<!-- End source of page2.asp -->

The error I get is simple...the little box with the X in it. If you just load up the page2.asp file, you are displayed "image.jpg" ; so the db calls are working fine. Also, all SSI's are working fine.

What am I doing wrong?!

. necronom .

ps. sorry for the cross-post...

you need to set the output content type to "image", because its going to dump whatever comes out from the database as an image

and
"Also, all SSI's are working fine"

what SSI's are working fine? there's none shown in the code

oooh ok. I'm trying to call an image that's on the server...not in a db.

so is it possible to call an image not in a db?

and the SSI's are in other scripts. (i didn't know if it mattered, so i just wanted to be clear as possible)

. necronom .

<%
strID = Request.Form("ID") 
strAccessDB = "Pics.mdb"
strConnect = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strAccessDB)
Set ObjConn = Server.CreateObject ("ADODB.Connection")
objConn.Open strConnect
Set objRec = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblImages.* From tblImages WHERE fldID=" & strID & ";"
objRec.Open strSQL, strConnect, 2, 3
strSRC = objRec("fldSRC")
Response.Redirect(strSRC)
%>

also, you might want to keep in mind to explicity close DB connections.. good practice when dealing with an Access backend

<%
strID = Request.Form("ID") 
strAccessDB = "Pics.mdb"
strConnect = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strAccessDB)
Set ObjConn = Server.CreateObject ("ADODB.Connection")
objConn.Open strConnect
Set objRec = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblImages.* From tblImages WHERE fldID=" & strID & ";"
objRec.Open strSQL, strConnect, 2, 3
strSRC = objRec("fldSRC")
objRec.Close()
ObjConn.Close()
Response.Redirect(strSRC)
%>

Boo-Yah! Thanx...that hit the spot perfectly!

Mucho Gracias!

. necronom .