[QUESTION] Are multiple active result sets supported?

[martinstuder]

Are multiple active result sets supported, i.e. can I have multiple active cursors on the same connection? In pyodbc, for example, this is supported via the connection property MultipleActiveResultSets=True.

[bewithgaurav]

Hi @martinstuder
We don't support MultipleActiveResultSets as of now.

[martinstuder]

Thanks for the feedback @bewithgaurav. Do you see this as something that will eventually be supported and would it therefore make sense to open a feature request for it?

I guess the current workaround is to use separate connections: https://github.com/microsoft/mssql-python/wiki/Database-Transaction-Management#concurrent-database-transactions