We are using DevForce 6.0.9 and INformix Dynamic Server 11.7.
First of all when version 6.0.7 came we where forced to do this to get it working:
TransactionSettings.Default = new TransactionSettings (System.Transactions.IsolationLevel.ReadCommitted, new TimeSpan(0, 1, 0), false);
If we set the last parameter to true all queries timed out. However the above workaround seemd to work untill we upgraded our database server from version 11.5 to 11.7. After that we get very misterious errors in between:
After running our Silverlight app. a few times (arbitrary) all queries start to hang "for ever". The only way to get it running again is to restart the Informix database engine. It is not enough to restart the Visual Studio Development web server. However as this is true we do not see anything wrong with the databas server. Other applictions can logon via ODBC or native Informix to the databas server and we can query the database, update, insert just as usulay. It is only the Silvelight application that seems to somehow be totally blocked to enter. Investigating Informix sessions, log files etc. does not reveal anything abnormal.
Any idea what might be causing this?