The details are:
· Visual Studio 2010
· .Net Framework 4.0
· Silverlight 4
· DevForce 2010 v6.0.6
· IBM DATA SERVER DRIVER PACKAGE V9.7.2
· IBM Data Server Provider for .NET 4.0 Beta.
· IBM Database Add-Ins for Visual Studio 2010 Beta.
After upgrading from DevForce v6.0.4 to v6.0.6 we get this error message when executing queries:
ERROR [58005] [IBM][IDS/NT32] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "16". Subcode = "2-8004D026".
We have followed the temporary workaround that is described on page 6 in the release notes for DevForce 2010 v6.0.6, which are to add the following line in our code:
TransactionSettings.Default = new TransactionSettings(System.Transactions.IsolationLevel.ReadCommitted, new TimeSpan(0, 1, 0), false);
This solves the problem.
We here by announce this problem as recommended by the release notes.