Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Images & Access97 & Web pages...

Posted on 1998-12-29
11
Medium Priority
?
182 Views
Last Modified: 2013-12-25
Anyone know how to display an Access db OLE field(with a image)in a web page(ASP)....

thank´s in advance
MG
0
Comment
Question by:mguedes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 10

Expert Comment

by:MasseyM
ID: 1857505
From my experience it is not possible.   You can only do it from the SQL server database.  Access does not have that capability.  Otherwise, you would use the GetChunk method.

I recommend that you just have a link to the imageand go from there.
0
 

Author Comment

by:mguedes
ID: 1857506
I know how to make this with the SQL server.....but now i want make the same with ACCESS......
0
 
LVL 6

Expert Comment

by:PBall
ID: 1857507
Since I have never try this before, just guessing...
This has nothing to do with Response.BinaryWrite method?

'get the data here....
set rs = con.execute("SELECT thumbnail FROM rec WHERE recID =...')

response.contenttype = "images/gif"
response.binarywrite rs("thumbnail")
0
Containers & Docker to Create a Powerful Team

Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.

 

Author Comment

by:mguedes
ID: 1857508
the problem was that the ole field does not have just binary data....it contain an header description(i guess)
0
 
LVL 2

Expert Comment

by:Jagar
ID: 1857509
MasseyM was right there is almost no way to do this.  In order to do it you are going to have to process what is stored in the database and strip out all the OLE headers and other information.  Then use the binarywrite method.  Sorry I don't know how to do it, but that is what needs to be done for this to work.
0
 
LVL 28

Expert Comment

by:sybe
ID: 1857510
It can be done allright, I am doing it all the time. It depends very much on how you put the image into Access. If you insert the image into Access using the normal OLE-procedure, Access will mess around with the byte code of the image (it converts it to bitmap). So, the only way is to store the exact binary code of the image in Access. For that you have to write some VBA code, or use another tool.

Once the image is fine in Access, you can display it with ASP easily:


<%
Response.ContentType = "image/GIF"


Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 5
Conn.CommandTimeout = 5
Conn.Open "DSN=Images"

strSQL = "SELECT * FROM Table WHERE ID=" & Request.Querystring("ID")
Set RSImage = Conn.Execute(strSQL)

Response.Binarywrite RSImage("Image")
%>
0
 

Author Comment

by:mguedes
ID: 1857511
Ok...i know this code. My problem is how to store the image in the access database...in binary field and from vb6...
0
 
LVL 28

Expert Comment

by:sybe
ID: 1857512
I use SA-FileUp from softartisans (www.softartisans.com) to store images into a database. I have seen it being done also with plain VBA. For that you have to use
AppendChunk.

Below follows a bit of code.

        MyData.Edit
       
        'Open Document
        Open strFile For Binary As #1 ' Open file.
        FileLength = LOF(1)
        i = 0
        Do While i < FileLength ' Loop until end of file.
            i = i + 1
            MyChar = InputB(1, #1)   ' Get one byte.
            MyData![Image].AppendChunk MyChar
        Loop
        Close #1    ' Close file.
       
        MyData.Update



0
 

Author Comment

by:mguedes
ID: 1857513
thank´s. do you know what kind of type must be the access field? submit an answer to glade you....
0
 

Author Comment

by:mguedes
ID: 1857514
i don´t need sa-fileup because i´m using a vb app to store the image in the database and next i upload the database to my www server.....and display the images with ASP´s...........
0
 
LVL 28

Accepted Solution

by:
sybe earned 60 total points
ID: 1857515
Access field must be OLE, so it can hold any binary information
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question