here is already an openDataReader

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

here is already an openDataReader

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

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

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.
Chris.Allen
 
Posts: 594
Joined: Thu Mar 12, 2009 4:17 pm


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron