Trial version for Visual Studio 2017

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for DB2
Post Reply
liusming
Posts: 2
Joined: Sun 04 Nov 2018 02:00

Trial version for Visual Studio 2017

Post by liusming » Sun 04 Nov 2018 02:55

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?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Trial version for Visual Studio 2017

Post by Shalex » Tue 06 Nov 2018 11:27

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.

Post Reply