here is already an openDataReader

Forum for users of SQL Compare schema synchronization utility

here is already an openDataReader

Postby jjorczak » Mon Oct 17, 2011 2:30 pm

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.
Posts: 3
Joined: Mon Oct 17, 2011 2:27 pm

Postby Chris.Allen » Fri Oct 21, 2011 9:37 am

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


In the Compare server connection box.
Posts: 579
Joined: Thu Mar 12, 2009 3:17 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests