I believe whatever it is in your application that is trying to get the
AsVariant of a blob is the cause. Gate this so that when a connection has
failed it won't be called.

I will change it so that it will be a little smarter about what error is
returned but you still need to fix something in your application as well, I
believe.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Bill Morrison" <bmorrison@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 07, 2001 9:18 AM
Subject: RE: [IBO] Graceful Recovery From DB Data Read Error


> As a brief explanation, CAPSITE is the remote db. The intent is to copy a
> blob from that remote db to another InterBase db (in this case on the
> localmachine).
>
> The error is being trapped in the CAPSITE.OnError event, and is being
> created by physically disconnecting the phone line during blob retrieval
> (simple yet effective).
>
> This error occuring is no big deal. I can handle it. However, the problem
> lies in that I can't seem to get CAPSITE to go back to csDisconnected, ie
> trying a CAPSITE.disconnect will raise this exception again, etc.
>
> Let me know if you need any more information Jason.
>
> Bill
>
>
TdmPCSThread.CAPSITEError($E7BF8C,335544721,$EA1684,$EA16B8,-902,$EA16EC,$EA
> 1720,True)
>
TIB_Component.DoHandleError($EB5BF0,335544721,$EA1684,$EA16B8,-902,$EA16EC,$
> EA1720,True)
>
TIB_Statement.DoHandleError($1A55F08,335544721,$EA1684,$EA16B8,-902,$EA16EC,
> $EA1720,True)
>
TIB_Component.DoHandleError($1A55F08,335544721,$EA1684,$EA16B8,-902,$EA16EC,
> $EA1720,True)
>
TIB_Statement.DoHandleError($1A55F08,335544721,$EA1684,$EA16B8,-902,$EA16EC,
> $EA1720,True)
>
TIB_Session.DoHandleError($1A55F08,335544721,$EA1684,$EA16B8,-902,$EA16EC,$E
> A1720,True)
> TIB_SessionBase.HandleException($1A55F08)
> TIB_Statement.GetBlobNodeData($1A5A3B4,nil,$1A58E50)
> TIB_BlobStream.Initialize
> TIB_BlobStream.Create($1A566B0,(521, 0, 0, 8, $E8F2CC, $E8F2CA, 8, ('A',
> 'T', 'M', 'I', 'M', 'A', 'G', 'E', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0,
> #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0), 9, ('S', 'H',
'O',
> 'R', 'T', 'T', 'E', 'R', 'M', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0,
> #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0), 6, ('S', 'Y', 'S', 'D',
> 'B', 'A', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0,
> #0, #0, #0, #0, #0, #0, #0, #0, #0, #0), 8, ('A', 'T', 'M', 'I', 'M', 'A',
> 'G', 'E', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0,
> #0, #0, #0, #0, #0, #0, #0, #0)),$E8B838,$EB5B30,bsmRead)
> TIB_BlobStream.CreateForColumn($E8DBE0,bsmRead)
> TIB_Statement.CreateBlobStream($E8DBE0,bsmRead)
> TIB_ColumnBlob.GetAsString
> TIB_Column.GetAsVariant
>
> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Monday, August 06, 2001 5:30 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Graceful Recovery From DB Data Read Error
>
>
> Look at the callstack and send me a copy while you are at it.
> Something is making it think it is still connected or you are doing
> something I should raise a more sensible exception for.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Bill Morrison" <bmorrison@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, August 06, 2001 2:03 PM
> Subject: [IBO] Graceful Recovery From DB Data Read Error
>
>
> > Greetings,
> >
> > I have run into the situation where during access to a remote DB
> > through a RAS dialup, the physical connection occasionally fails. This
> > generates the 335544721 error, which I can trap in the OnError event of
a
> > TIB_Connection and Transaction.
> >
> > However, the TIB_Connection still believes itself to be connected,
> > and an attempt to .Disconnect it will respawn the error.
> >
> > What is the proper way to handle this situation?
> >
> >
> > Thanks in advance,
> >
> >
> >
> > Bill Morrison
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>