I have been getting an error message in my sql task: There is already an open DataReader associated with this Command which must be closed first.

Does anyone know how to troubleshoot this error.

Some of the things I have tried is restarting the Visual Cron service where its hosted, restarted my Sql Server, Take my database offline & online, alter my database with setting single user with rollback immediate and then resetting it to multi user, or anything really that I would think would kill any connection.

Any help is appreciated, thanks!

I have been getting an error message in my sql task: There is already an open DataReader associated with this Command which must be closed first.

Does anyone know how to troubleshoot this error.

Some of the things I have tried is restarting the Visual Cron service where its hosted, restarted my Sql Server, Take my database offline & online, alter my database with setting single user with rollback immediate and then resetting it to multi user, or anything really that I would think would kill any connection.

Any help is appreciated, thanks!

Hi,
So this is a windows error, and a quick googling shows a couple of solutions, have you tested them?
https://stackoverflow.co...-command-which-must-be-c 
https://stackoverflow.co...ommand-which-mu/18475525 
https://www.codeproject....ataReader-associated-wit 

---