# Connect to Azure Synapse Analytics SQL Pool

**URL:** <https://forums.toadworld.com/t/connect-to-azure-synapse-analytics-sql-pool/55734>\
**Category:** Toad for SQL Server\
**Created:** [July 25, 2022, 7:38pm UTC](https://forums.toadworld.com/t/connect-to-azure-synapse-analytics-sql-pool/55734 "2022-07-25T19:38:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![osmel.b](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/osmel.b/32/14913_2.png) [@osmel.b](https://forums.toadworld.com/u/osmel.b)\
**Post date:** [July 25, 2022, 7:38pm UTC](https://forums.toadworld.com/t/connect-to-azure-synapse-analytics-sql-pool/55734/1 "2022-07-25T19:38:55Z")

</div>

When I try to connect to an SQL Pool in Azure Synapse Analytics with TOAD for SQL, the database gives me the error "@@trancount is not supported".

Does anyone else have this error?

---

<div class="post-metadata">

**Author:** ![arevalg1](https://avatars.discourse-cdn.com/v4/letter/a/d07c76/32.png) [@arevalg1](https://forums.toadworld.com/u/arevalg1)\
**Post date:** [March 27, 2024, 4:45pm UTC](https://forums.toadworld.com/t/connect-to-azure-synapse-analytics-sql-pool/55734/3 "2024-03-27T16:45:27Z")

</div>

have anybody resolve this problem. I am having the same issue.  
any ideas?