Solved

Display Blob in MS Access Report using Oracle

Posted on 2004-09-27
7
1,399 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
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now