Re: Copying BLOB's out of Oracle w/ Access 97

Are u sure the doc file is not a Word 2000 file or something else.. ? If it is working normally with other files, then the problem lies with the file,or with it's version.. also are u sure it is a .doc ? trying renaming it to .xls and see if it has not been renamed to .doc or something ... it happens you know :-)

It cannot be the binary/ascii problem.

Regards,
Deepak

"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 Wed Aug 01 2001 - 12:16:53 CEST