Hi,

Our company uses an application called "Prolaw" which has a SyBase
backend database. Since its reporting system is quite weak, I've been
importing data in to Access using ODBC, then using Access for reports.

The only problem is that I'm unable to access data stored in BLOBs in
the Sybase database. I've tried using getChunk(), MS Knowledge base
articles 210486 (Reading, Storing and Writing BLOBs) and 194975
(Howto: Read and Write BLOBs Using GetChunk and AppendChunk).

When using getChunk() or article 210486's writeBlob() function, the
data extracted is a sequence of "?" and some other garbage in the
string (strings were much shorter than the actual data stored).

When using artical 194975's blobToFile() function, the data extracted
is the field's length.

Any ideas about extracting these stubborn BLOBs from SyBase?

Much thanks,
Oren

"Oren" <oren (AT) gdblegal (DOT) com> wrote

the data thus (assuming "ExtractData" as your extracted object):
StrConv(ExtractData,vbUnicode)

....and see if it produces a readable result. Just a thought.