We are attempting to use the System.Transactions.TransactionScope class as described within the following MSDN article to allow transactional updates to two DB2 databases:
Whenever I invoke the connection's Open() method within the TransactionScope, the following exception is thrown:
IBM.Data.DB2.DB2Exception: ERROR 58005 IBM
at IBM.Data.DB2.DB2ConnPool.a(DB2Connection A_0, String A_1, a& A_2, Object& A_3)
at DB2TestConnection.Form1.button1_Click(Object sender, EventArgs e) in D:\My Documents\Visual Studio\Projects\DB2TestConnection\DB2TestConnection\Form1.cs:line 39
The Information Center does not list Reason Code 16 within the list of possible codes.
I have seen errors relating the use of ADO 2.1 from classic ASP on google - with a registry fix to disable ODBC's resource pooling. As we are dealing with the IBM.Data.DB2 2.0 provider, I am unsure if this is a valid fix and if so where and how to change the configuration.
Any help on this would be greatly appreciated. Thanks in advance.