What are the challenges you face when working across database platforms? Take the survey
Options

here is already an openDataReader

jjorczakjjorczak Posts: 5
edited October 21, 2011 5:37AM in SQL Compare Previous Versions
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.

Comments

  • Options
    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.
Sign In or Register to comment.