How To Solve MS DTC Error For External Database Connector
0
Hi all, I'm connecting to a Microsoft SQL database using the External Database Connector (v5.0.1). I have to run an UPDATE query, but I keep getting the following error when attempting to run the query from Studio Pro (v10.18.5): Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x80070057(The parameter is incorrect.). When running the query, using the same username and password as set in Studio Pro, the query succeeds. Select calls execute without an issue from Studio Pro, it is only the update query that experiences issues. For reference, here is the query: update Table1 SET T1_Column1 = {Parameter1} WHERE T1_Column2 IN (select t1.T1_Column2 from Table2 t2 left join Table1 t1 on t2.T2_Column1 = t1.T1_Column2 and t1.T1_Column3 = 1958 where t2.T2_Column1 = {APQPInternalReference}) Any advice would be appreciated.
asked
Nico Mouton
1 answers
0
Try updating the database connector, I think there are related fixes in one of the latest releases.
Also, the issue might just occur at design time. Try running the app and execute the same query then.