When I execute the DB Query Reader node,just like “select top * from table”, an error occurs Execute failed: ‘@@TRANCOUNT’ is not supported [image] This is my JDBC parameter configuration, should I add anything else? [image]

@sweet_soup most likely you have to change these settings [image] Querying Data in a Serverless SQL Pool in Azure Synapse KNIME Analytics Platform Hello everyone, I have good news for you. With the next release of the KNIME Analytics Platform, which is planned for summer, the Microsoft SQL Server Connector will support disabling of transactions. Once disabled you can use it to connect to a serverless SQL pool in Azure Synapse. After the release you can disable transactions by unselecting the Enable flag in the Transaction section of the Advanced tab as shown here: [image] We will also add a section about this to the database documentat…

Knime 5.3.2 DB Query Reader Execute failed

KNIME Analytics Platform

mlauber71 December 4, 2024, 8:00am 2

@sweet_soup most likely you have to change these settings

1 Like