# Knime 5.3.2 DB Query Reader Execute failed

**URL:** <https://forum.knime.com/t/knime-5-3-2-db-query-reader-execute-failed/85077>\
**Category:** KNIME Analytics Platform\
**Tags:** bug\
**Created:** [December 4, 2024, 3:48am UTC](https://forum.knime.com/t/knime-5-3-2-db-query-reader-execute-failed/85077 "2024-12-04T03:48:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sweet\_soup](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/f08c70/32.png) [@sweet\_soup](https://forum.knime.com/u/sweet_soup)\
**Post date:** [December 4, 2024, 3:48am UTC](https://forum.knime.com/t/knime-5-3-2-db-query-reader-execute-failed/85077/1 "2024-12-04T03:48:28Z")

</div>

When I execute the DB Query Reader node,just like “select top \* from table”, an error occurs  
Execute failed: ‘@@TRANCOUNT’ is not supported

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/b/3b9052020a0dc10719c7a1bc136430d876d14d96.png)  
This is my JDBC parameter configuration, should I add anything else?  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/2/32d90d67caa2481dc3a59eb72227b61849db74a1.png)

---

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [December 4, 2024, 8:00am UTC](https://forum.knime.com/t/knime-5-3-2-db-query-reader-execute-failed/85077/2 "2024-12-04T08:00:52Z")

</div>

@sweet_soup most likely you have to change these settings

> [@Querying Data in a Serverless SQL Pool in Azure Synapse](https://forum.knime.com/t/querying-data-in-a-serverless-sql-pool-in-azure-synapse/38640/12):
>
> 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](https://kni.me/n/lbG8X3On6ol70XyD) 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: We will also add a section about this to the [database documentat…](https://docs.knime.com/latest/db_extension_guide/index.html#connecting_to_ms_sqlserver)

---

<div class="post-metadata">

**Author:** ![sweet\_soup](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/f08c70/32.png) [@sweet\_soup](https://forum.knime.com/u/sweet_soup)\
**Post date:** [December 4, 2024, 9:26am UTC](https://forum.knime.com/t/knime-5-3-2-db-query-reader-execute-failed/85077/3 "2024-12-04T09:26:38Z")

</div>

I succeeded, thank you very much 🤗

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [December 11, 2024, 9:26am UTC](https://forum.knime.com/t/knime-5-3-2-db-query-reader-execute-failed/85077/4 "2024-12-11T09:26:58Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.