Devart Forums

Hello:

I am try to use dotconnect trial version in Visual studio 2017 but fail.

I try to connect to database server with dotconnect driver show following error.

It shows error 58005{IBM} SQL0998N Reason =16 subcose =1 SQLSTATE =58005

Would you kindly advise how to solve that? Shall I add license to VS 2017?

Refer to https://www.ibm.com/support/knowledgece ... opic2.html :
"16 - A failure occurred with the Microsoft Distributed Transaction Coordinator (MSDTC). Possible subcodes are:
01 - The database manager is unable to communicate with the MSDTC."

Solution should be the following: navigate to Control Panel > Administrative Tools > Services and make sure that the "Distributed Transaction Coordinator" service is running.

JIC: by default dotConnect for DB2 sets "enlist=false;" in the connection string (we preserved this behavior for a backward compatibility) but IBM.Data.DB2 uses "enlist=true;". So please set explicitly "enlist=true;" in Devart.Data.DB2.DB2Connection.ConnectionString not to break the behavior of IBM.Data.DB2.