<%@ Language=VBScript %>
<%Response.ContentType = "image/gif"%>
Set objRS = Server.CreateObject("ADODB.Recordset")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("test.mdb")
objRS.Open "select * from test",conn
This time it showed some weird characters as output.
I realise I sound confusing but I do have a test.mdb with a "test" table. And I can display another field from the table which is text. Could it be the datatype in the db thats causing the problem?
I have pict column with an "OLE Object" datatype.
To add a picture to the column
I select Insert--> Object
That shows a pop up.
Select option "Create From File option" and browse to select a gif file.
Am I right? Is there any other way of adding pictures to the db?
I am currently looking at ASPUpload and XUpload for a drag and drop upload option. If anyone has any other options would love to hear and check them out.
I also have the problem of all the images that are currently in MS Access 2000 that were drag and droped as OLE Objects. Over 50,000 documents. I need to convert them to BLOB's and keep all of the data that is in the same record with them so that I can link and display them on the web.