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/