He has a transaction and datasets that are not all in the same transaction.
Or, a dataset pointing to a connection and a transaction that are not
pointing to one another.
IOW, the transaction the statement (or dataset) is pointing to is not
pointing to the same connection.

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

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Monday, August 06, 2001 2:19 AM
Subject: Re: [IBO] Unexplained behavior from DefaultSession


> Hi Bill!
>
> Since no-one seems to have answered you, I guess I can try (though the
main
> benefit from me answering will probably be to remind Geoff and Jason about
your
> problem).
>
> You write about connections and queries, but what about your transactions?
I
> know nothing about threads, but assume that they do not remove the need
for
> transactions. And if you have them, do you explicitly call commit or do
you have
> AutoCommit set to true? Do you call StartTransaction at all (not saying
that you
> should, I never make such calls)? The error message seems to indicate that
it is
> trying to commit a transaction that has not been started.
>
> Set
>
> Bill Morrison wrote:
>
> > Greetings All!
> >
> > IBO 3.5.Ag, IB 5.6
> >
> > I'm working on a multi-threaded application with the following
> > characteristics:
> >
> > Main form maintains 1 TIB_Connection, but has two others it occasionally
> > uses.
> >
> > Main form can create a thread, which creates it's own two
TIB_Connections
> > and runs queries from them.
> >
> > Each TIB_Connection has it's own TIB_Transaction, with explicit code
doing
> > commits/etc.
> >
> > The problem occurs when I create the thread, one of the thread databases
is
> > over a slow connection (dialup), and I am retrieving blobs from that
> > database.
> >
> > Intermittently the following error occurs between image reads :
> >
> > ISC Error Code : 335544332
> > invalid transaction handle (expecting explicit transaction start)
> >
> > The callstack looks like this:
> >
> > TIB_SessionBase.HandleException
> > TIB_Transaction.API_Commit <--Self.Name = DefaultSession
> > TIB_Transaction.CheckOAT
> > TIB_Transaction.DoTimer(false)
> >
> > Now, I have tried everything I could think of, including adding
TIB_Sessions
> > and the like, but this error keeps popping up. Any ideas on how I can
fix it
> > would be greatly appreciated.
> >
> > Thanks in advance!
> >
> > Bill Morrison
> >
> > -----Original Message-----
> > From: Damian Dowling [mailto:it-manager@...]
> > Sent: Friday, August 03, 2001 8:56 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] IB Standard Actions
> >
> > Hi
> >
> > I was looking through the standard actions for IB and was surprised to
find
> > that they do not use Announce Focus and Received Focus like the IB
Bars -
> > Is there any plans to do this?
> >
> > Also are there any plans to include Standard Actions for searching,
> > sorting, etc?
> >
> > Thanks for your time.
> >
> > Damian Dowling
> > IT Manager
> > Pallas Foods Ltd
> >
> > Phone: + 353 69 20200
> > Fax: + 353 69 20201
> > Email: it-manager@...
> >
> >
> >
> > 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/
>
>