Bug #38200 There is an already an open datareader associated with this connection.....

• Submitted: 17 Jul 2008 14:47
• Modified: 2 Oct 2008 7:25
• Reporter: R Roberts
• Status: Can't repeat
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: 5.1
• OS: Windows
• CPU Architecture: Any

[17 Jul 2008 14:47] R Roberts

Description:
Hi

I am using MySQLConnector.Net 5.1, SQLYog CommunityEdition v6.16, VS 2005 (C#).

I found everytime I used the XSD and with wizard form, if I tried to modify SQL query or select a stored procedure.

My AppConfig file (connection string):

...;Allow Zero Datetime=true;use procedure bodies=True;use old syntax=false" providerName="MySql.Data.MySqlClient"

I keep getting this error on the wizard form:

Error Message: There is an already an open datareader associated with this connection which must be closed first

Any ideas or suggestions will be appreciated.

Thanks

How to repeat:
1. Go to XSD in VS 2005 and create table adapter
2. Pick stored procedure for SELECT dropdown list or create ad-hoc sql text

[18 Jul 2008 10:13] Tonci Grgin

Hi and thanks for your report.

Let me search bugsdb as I'm sure this is a duplicate of, at least, several reports.

[24 Jul 2008 13:30] Tonci Grgin

Similar thing reported in Bug#29098. Do you by any chance use old version of c/NET 5.1?

[24 Jul 2008 13:33] Tonci Grgin

Bug#28537 and several of yours (LIMIT, IFNULL) maybe?

[24 Jul 2008 13:58] R Roberts

Yes I did use C#/Net 5.1 but then I have upgraded to 5.2.1

[2 Oct 2008 7:25] Tonci Grgin

I am unable to repeat the problem with VS2005Pro:

create table bug38200 (Id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, SomeText VARCHAR(50));

delimiter //

CREATE PROCEDURE `sp_bug38200INS`(IN t VARCHAR(50))
begin
INSERT INTO bug38200 VALUES(NULL,t);
end//

CREATE PROCEDURE `sp_bug38200DEL`(IN i INT)
begin
 DELETE FROM bug38200 WHERE Id = i;
end//

CREATE PROCEDURE `sp_bug38200UPD`(IN i INT, IN t VARCHAR(50))
begin
 UPDATE bug38200 SET SomeText = "Update" WHERE Id = i;
end//

delimiter ;

See attached image too.

[2 Oct 2008 7:26] Tonci Grgin

Property editor with everything changed from wizard

Attachment: Bug38200.JPG (image/jpeg, text), 42.87 KiB.