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?
Trial version for Visual Studio 2017
Re: Trial version for Visual Studio 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.
"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.