Connection is busy with results for another command (0) (SQLExecDirectW) about pyodbc HOT 3 CLOSED

Try adding MARS_Connection=Yes to your connection string.

from pyodbc.

Try adding MARS_Connection=Yes to your connection string.

Thank you @v-chojas
yes, we have tested with MARS_Connection=Yes connection string. Connection busy error is resolved however faced application slowness more than thrice the execution time of each APIs.

Is there a way to handle it without MARS_Connection or handle slowness

from pyodbc.

It sounds like your application is attempting to use multiple active resultsets, so you'll need to figure out how to change it to not do that. Unless MARS is enabled, the driver can only process one query at a time on a connection.

from pyodbc.