Database connection is busy with results from another command

Question

What I am trying to do was to fetch data from an data API which I did using Python and the data that was received as response from the API, was stored in panda dataframe.

Then those dataframes were converted to csv and the csv was pushed to Azure blob storage.

The same program post pushing the csv to Azure creates an external table on MS-SQL Server.

Post which the data is transferred to the main table from the external table.

This process is run in loop for multiple tables. And the program breaks after few iterations.

The code for one of the procedures is available at this Stackoverflow post. Move data from a external table to main table using procedure

This image is a screenshot of the error I am getting. http://prntscr.com/ocxmwu

Answer 1

There is issue with your connection string of your database.

So, you only need to make "MARS_Connection=yes". 

It will work.