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?
LVL 1
colin_palmerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Alan WarrenConnect With a Mentor Applications DeveloperCommented:
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
 
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
 
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 WarrenApplications DeveloperCommented:

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.