here is already an openDataReader

jjorczak

When I run SQL Data Compare 9.1 to synchronize an Azure database to a local database, I get this error: "The connection operation could not be completed: There is already an openDataReader associated with this Command which must be closed first."

I rebooted the machine to clear everything out and it still happens.

Chris.Allen

You need to add MultipleActiveResultSets=True to a connection string in SQL (Data)Compare itself, so try:

servername;MultipleActiveResultSets=True

In the Compare server connection box.