> I've noticed a strange thing while trying to find this problem:
>
> The point of failure is definitely when I'm trying to read a text
> blob from
> the database. However, it happens on seemingly random records and
> sometimes
> the loop runs through all the records without a problem.
>
> Here are some more details:
> The blob field is defined as a domain, such as this:
> CREATE DOMAIN "XML_BLOB" AS BLOB SUB_TYPE TEXT SEGMENT SIZE 400;

why are you fooling around with segment size?
try the default 80
Alan

>
> The blobs contains XML data of around 6KB in size. I access the
> blob using a
> simple statement such as this:
> XMLStr := MyTable.FieldByName(SOME_XML_FIELD').AsString;
>
> I sit in a loop, reading the blob data from the result set.
> XMLStr is simply
> a string value. The statement above causes three random problems.
> Sometimes
> it gives an "error reading connection" type error, sometimes it gives an
> "invalid BLOB handle" error, and sometimes it simply hangs dead on the
> statement as if something is sitting in a tight loop. Very weird indeed!
>
> I actually do have other IBO components on the DataModule: They are: 1)
> TB_SessionProps and 2) TIB_Events. I don't know if any of these two could
> perhaps cause a problem?
>
> Regards,
> Don