• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1461
  • Last Modified:

Display Blob in MS Access Report using Oracle

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
colin_palmer
Asked:
colin_palmer
  • 3
  • 2
  • 2
1 Solution
 
Gelu_ParfenieCommented:
Hi,
One question.
Are you able to see the pictures direct in linked table ?

Gelu
0
 
Gelu_ParfenieCommented:
I mean if you double-click on the field in linked table.
Thanks,
Gelu
0
 
colin_palmerAuthor Commented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
colin_palmerAuthor Commented:
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
 
Alan WarrenCommented:
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
 
Alan WarrenCommented:

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
 
colin_palmerAuthor Commented:
The sample was a big help, many thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now