this may help you too:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='128'

you may have another connection open to the database that is using
transaction id 7, until
that connection does at least a commit, these figures won't change.

>From: "Chooi-Ting" <goonct@...>

>more info:
>my application use odbc-api library to connect to database. before I
>run the application, the value for oldest active is 7 and next
>transaction is 13250. After i run the application, the oldest active
>is still 7 and the next transaction has increased to 19082.

_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger