?
Solved

Display Blob in MS Access Report using Oracle

Posted on 2004-09-27
7
Medium Priority
?
1,432 Views
Last Modified: 2013-11-28
Hi, I am using an Oracle database, with images stored as Blobs.

Im trying to display these in an Access report (Access 2000), im using a bound object frame to display the Blob but im just getting a blank box.  I have a link table in Access to the table in Oracle and I tried dragging the field into the report, which created the bound object frame and that doesnt work either.

Any ideas?
0
Comment
Question by:colin_palmer
[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
  • 3
  • 2
  • 2
7 Comments
 

Expert Comment

by:Gelu_Parfenie
ID: 12159182
Hi,
One question.
Are you able to see the pictures direct in linked table ?

Gelu
0
 

Expert Comment

by:Gelu_Parfenie
ID: 12159197
I mean if you double-click on the field in linked table.
Thanks,
Gelu
0
 
LVL 1

Author Comment

by:colin_palmer
ID: 12159232
Hi

I cannot see the pictures direct in the linked table, it just says 'OLE Object'

I have tried using a parse through query too with SQL to pull out certain rows from the Oracle database that I know have pictures in them but this still doesnt work either.
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 1

Author Comment

by:colin_palmer
ID: 12159266
Sorry, just read your second message.

I tried double clicking on field and I get an error message:
A problem occured while MS Access was communicating with the OLE Server or ActiveX control
Close the OLE Server & restart it outside of MS Access
0
 
LVL 26

Accepted Solution

by:
Alan Warren earned 2000 total points
ID: 12161181
Hi Colin,

not real sure about oracle but I have posted a JET/MDB/ADO/SQL sample demonstrating BLOB manipulation in forms here:
  http://www26.brinkster.com/alzowze/blobs.asp

I have  also applied this to reports in the same fashion.

I expect that all you would need to do is create an oracle stored procedure similar to the stored query in the sample, then change the connection string from a Jet connect to an Oracle connect string.

You will find your oracle equivalents for Access ADO data types here:
http://www.able-consulting.com/ADODataTypeEnum.htm

And your Oracle OLE DB Provider Strings here:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm


Dont hessitate to  contact me if you need any more info..



Regards Alan


0
 
LVL 26

Expert Comment

by:Alan Warren
ID: 12161450

Using reports I created an image control and called a function to extract the blob to file on report open event.

Private Sub Report_Open(Cancel As Integer)
 
  If Not IsNull(glCusID) Then
    Me.imgSpotter.Picture = putBLOBInFile(glCusID)
  End If

End Sub

If you are displaying many images I think you use the  OnFormat Event of the Detail section to invoke the function that extracts the blobs.

Alan
0
 
LVL 1

Author Comment

by:colin_palmer
ID: 12167740
The sample was a big help, many thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

765 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