Solved

Display Blob in MS Access Report using Oracle

Posted on 2004-09-27
7
1,407 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

831 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