Subject RE: [IBO] Graceful Recovery From DB Data Read Error
Author Bill Morrison
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/