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.
· Share on Twitter

Comments

  • Chris.AllenChris.Allen Posts: 579
    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.
    · Share on Twitter
Sign In or Register to comment.