I would certainly change the iso to committed.
Kevin


_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Roger Pullen
Sent: Wednesday, May 18, 2005 11:00 AM
To: ibobjects@yahoogroups.com
Subject: [IBO] ASTA, IBO and Transactions


All - we have an IBO ASTA server app running that
is now generating deadlocks. We are experiencing
an increase in users over recent months (about 10 - 12 now)
and have noted the IBTransaction on the ASTA server
is set to Concurrency - having read up on all this and
(tried) to understand it I believe this may be not the best setting
- committed being possibly better.

This ASTA server connects to a FB1.5 db that also has a "conventional"
IBO app connected as well whose transaction isolation
is set to committed and does not (usually) show any problems.

Is this deduction correct - bearing in mind the transaction
has autocommit set to TRUE. Alternativly, of course, it
may be my client app part that is wobbling....

Regards

Roger Pullen



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/


* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]