Re: Copying BLOB's out of Oracle w/ Access 97
From: Eric from Speco <eric_at_speco.com>
Date: Mon, 6 Aug 2001 11:22:13 -0500
Message-ID: <9kmg6v$2ab$1_at_bob.news.rcn.net>
> I'm using Access 97 and Oracle 7.3.
> I'm trying to copy blobs out of Oracle w/ Access using the GetChunk
method.
> I have several types of blobs in the Oracle DB. Some are .doc, some are
> .xls, some are .dwg, and more.
> This particular one I'm trying is a .doc file.
> I can copy the blob out and name it testfile.doc, and open the file. What
I
> see in the file, though, is not correct. A sample of what I see is
>
> ?? - - ! ??# $ % & ' ( ) ????,
>
>
> ? d?1Table ????????s?????? ????????
>
> It looks like I'm missing something. Maybe a conversion from Binary to
> ASCII??? Not sure if that's even possible.
>
> Any ideas anyone?
>
>
>
Received on Mon Aug 06 2001 - 18:22:13 CEST
Date: Mon, 6 Aug 2001 11:22:13 -0500
Message-ID: <9kmg6v$2ab$1_at_bob.news.rcn.net>
I'm not really that familiar w/ blobs so please forgive my ignorance. However I can offer a general troubleshooting method that may work.
Is the blob viewable in it's enviornment? (ie is there a viewer?) Is it OK there?
If so export it using another tool other than the VB OCX.
If it's OK then you have a problem w/ the OCX code. If it's not OK then you have a server side issue to fix.
Either way you've split the problem in half and know where to look.
Bryce Moulton <brycemoulton_at_eaton.com> wrote in message news:9k6feo$7a4_at_interserv.etn.com...
> I'm using Access 97 and Oracle 7.3.
> I'm trying to copy blobs out of Oracle w/ Access using the GetChunk
method.
> I have several types of blobs in the Oracle DB. Some are .doc, some are
> .xls, some are .dwg, and more.
> This particular one I'm trying is a .doc file.
> I can copy the blob out and name it testfile.doc, and open the file. What
I
> see in the file, though, is not correct. A sample of what I see is
>
> ?? - - ! ??# $ % & ' ( ) ????,
>
????????????????????????????????????????????????????????????????????????????
>
????????????????????????????????????????????????????????????????????????????????????.
> ????????????????Root Entry ? ?? ??? ???? a???? ? À ?
> ? d?1Table ????????s?????? ????????
>
> It looks like I'm missing something. Maybe a conversion from Binary to
> ASCII??? Not sure if that's even possible.
>
> Any ideas anyone?
>
>
>
Received on Mon Aug 06 2001 - 18:22:13 CEST