Question

I got an error message that says:

"There is already an open DataReader associated with this Command which must be closed first."

What's the problem?

Answer 1

Your connection string needs to have "MultipleActiveResultSets=True" added to it.

To use SQL Server, set your connection string to

Server=server;Initial Catalog=database;MultipleActiveResultSets=true;Integrated Security=SSPI; for Integrated Authentication

or

Server=server;Initial Catalog=database;MultipleActiveResultSets=true;User Id=sqlserveruser;Password=sqlserverpassword;

for SQL Server Authentication

Answer 2

Michael's answer will solve this problem on SQL Server 2005 and SQL Server 2008. If you're getting this message and you're running SQL Server 2000, make sure this is present in your connection string:

Provider=sqloledb