How to Insert documents to a BLOB field

[acelestial]

Hi,
I have an Access Front-End application and an Oracle Back-End for my tables.
I have a BLOB field in one of the tables.
I use Access form to insert my documents in a record to the BLOB field by
right-clicking the OLE Object bound field in the form, then Insert Object
(embedded).
My problem is, it displays garbage when I use intermedia to display a
particular document using this sample hyperlink
"http://servername/intermedia/mediaget/myproceduretodisplaydoc/2"
Am I doing the right process in inserting documents in a BLOB field using
Access as front-end and Oracle as back-end?
My index is working fine. It's only when I display/open the link above to
view the document that I get garbage data instead.
Any help is much appreciated.
TIA,
Arman

[Billy Verreynne]

acelestial wrote:

> I use Access form to insert my documents in a record to the BLOB field by
> right-clicking the OLE Object bound field in the form, then Insert Object
> (embedded).
> My problem is, it displays garbage when I use intermedia to display a
> particular document

Question. Is an OLE object not "packaged" in some way? If so, then it needs
to be unpackaged before it can be displayed. It is unlikely that
intermedia will know it is a Microsoft OLE object and needs to be
unpackaged.

> My index is working fine. It's only when I display/open the link above to
> view the document that I get garbage data instead.

What document type do you save as the OLE object? How sure are you that
intermedia can display that document type or even recognise its format?

--
Billy

[acelestial]

Hi,
I'm not sure about the OLE object not "package". Kindly explain or point me
to some links about it.
I guess, OLE object is working fine because I can open documents which I
inserted using Insert Object on the form by double-clicking on them. The
problem really is when displaying these documents inserted using Insert
Object on the form in interMedia. I did some test of inserting/importing
documents directly into the Oracle table BLOB field and they did display
fine in interMedia. But on the form, those documents which have been
inserted directly into the table are not showing in the OLE field even if I
double-click them to open, it displays a message instead:
"A problem occurred while myDatabase was communicating with the OLE server
or ActiveX Control.
Close the OLE server and restart it outside of myDatabase. Then try the
original operation again in myDatabase."
I mostly insert MS Word documents.
Thanks,
Arman

"Billy Verreynne" <vslabs@onwe.co.za> wrote in message
news:aspfrc$abg$1@ctb-nnrp2.saix.net...

> acelestial wrote:
>

> > I use Access form to insert my documents in a record to the BLOB field

by

> > right-clicking the OLE Object bound field in the form, then Insert

Object

> > (embedded).
> > My problem is, it displays garbage when I use intermedia to display a
> > particular document

>
> Question. Is an OLE object not "packaged" in some way? If so, then it

needs

> to be unpackaged before it can be displayed. It is unlikely that
> intermedia will know it is a Microsoft OLE object and needs to be
> unpackaged.
>

> > My index is working fine. It's only when I display/open the link above

to

> > view the document that I get garbage data instead.

>
> What document type do you save as the OLE object? How sure are you that
> intermedia can display that document type or even recognise its format?
>
> --
> Billy

[acelestial]

Hi,
Sorry for the duplicate responses. Connection problem. :)
Thanks,
Arman


"Billy Verreynne" <vslabs@onwe.co.za> wrote in message
news:aspfrc$abg$1@ctb-nnrp2.saix.net...

> acelestial wrote:
>

> > I use Access form to insert my documents in a record to the BLOB field

by

> > right-clicking the OLE Object bound field in the form, then Insert

Object

> > (embedded).
> > My problem is, it displays garbage when I use intermedia to display a
> > particular document

>
> Question. Is an OLE object not "packaged" in some way? If so, then it

needs

> to be unpackaged before it can be displayed. It is unlikely that
> intermedia will know it is a Microsoft OLE object and needs to be
> unpackaged.
>

> > My index is working fine. It's only when I display/open the link above

to

> > view the document that I get garbage data instead.

>
> What document type do you save as the OLE object? How sure are you that
> intermedia can display that document type or even recognise its format?
>
> --
> Billy