| Author |
Message |
sunspot07
Joined: 04 Feb 2012
Posts: 4
Location: New Castle Colorado
|
 Posted: Sat Feb 04, 2012 5:23 pm Post subject: open DataReader error |
 |
|
Hi,
I downloaded an evaluation copy of SQL Data Compare 9.0 to see if it would help me keep a SQL Azure and a local SQL Server database contents in synch. When I run the application, I always get an error when trying to register the Azure database " There is already an open DataReader associated with this Command which must be closed first". I cannot continue from there. I uninstalled the app, and used the link under the sticky, but no difference. As part of the evaluation, SQL Compare 10 was also installed, and that tool works fine - it can compare my local and Azure databases. But, I have more of a need to compare the data, and possible migrate it, and I was hoping SQL Data Compare would be the tool. I have version 9.1.0.365 installed.
Thanks in advance for any help solving this! |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
|
| Back to top |
|
|
sunspot07
Joined: 04 Feb 2012
Posts: 4
Location: New Castle Colorado
|
| Posted: Mon Feb 06, 2012 4:02 pm Post subject: |
|
|
Same results with that version...  |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Mon Feb 06, 2012 4:29 pm Post subject: |
|
|
Please can you follow the instructions in this document to enable logging and then recreate the issue.
http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/knowledgebase/logging_and_log_files
Ensure that you disable logging afterwards. If you have the opportunitry to send us an error report too (a link similiar to "Is the problem serious? send us a report..." may be displayed in the error message) then please do so.
Please send the generated error log to support@red-gate.com with the ticket reference F0056999 in the subject line.
_________________
Chris Kelly
Technical Support Engineer |
|
| Back to top |
|
|
sunspot07
Joined: 04 Feb 2012
Posts: 4
Location: New Castle Colorado
|
| Posted: Mon Feb 06, 2012 5:23 pm Post subject: |
|
|
I emailed the log file and a screen shot of the error message - I'm not real clear on what other error report may be available??
Thanks! |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
|
| Posted: Tue Feb 07, 2012 4:33 pm Post subject: |
|
|
Can you try entering the following into the 'Server' field.
servername;MultipleActiveResultSets=True
So it could look like this;
MySQLServer2008R2;MultipleActiveResultSets=True
Then re-try the steps that led to the error previously. How does it go?
_________________
Chris Kelly
Technical Support Engineer |
|
| Back to top |
|
|
sunspot07
Joined: 04 Feb 2012
Posts: 4
Location: New Castle Colorado
|
| Posted: Tue Feb 07, 2012 4:52 pm Post subject: |
|
|
| that fixed it - THANKS! |
|
| Back to top |
|
|
|
