Bug #28537 QError in adding new stored procedure to dataset(designer)

• Submitted: 19 May 2007 12:08
• Modified: 29 May 2007 6:33
• Reporter: Psy After
• Status: Closed
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 5.1.0
• OS: Windows (XP Sp2)
• CPU Architecture: Any
• Tags: query, Wisard

[19 May 2007 12:08] Psy After

Description:
When i try to add new stored procedure, so got this error:

The wizard detected the following problems when configuring the TableAdapter: 
"`sp_name`":
Generated SELECT statement.
Value cannot be null.
Parameter name: key

and procedure added without parameters

How to repeat:
Add new dataset
go to designer
rigth click-> Add -> Table Adapter
select connection (or add new)->next
check "Use  existing stored procedure" -> next
select stored procedure from list (something with parameters)->next->next
here we see error(warning)

[23 May 2007 12:39] Tonci Grgin

Hi and thanks for your reports. We are actively working on both of them.

[28 May 2007 16:50] Tonci Grgin

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Explanation: Hi, I've retested with c/NET 5.1.1 and the error is gone. Please try new version.

[29 May 2007 6:10] Psy After

Hi
I installed last version, but wizard still closed:((

tried on fresh Win XP sp2, VS 2005 SP1

[29 May 2007 6:24] Tonci Grgin

Hi.

Could it be that a particular SP is causing troubles? Can you test with fresh install of *MySQL server* and 1 or 2 simple SP's? What is your connection string?

[29 May 2007 6:33] Psy After

I tested all in full fresh envirment(windows, mysql 5.0.27, visual studio 2005), but after installing service pack 1 for VS2005.
I'll  search for clear VS2005 without sp1.
my connection string: 
Server=localhost;User Id=root;Database=...;Persist Security Info=True;CHARSET=utf8;

[23 Apr 2008 13:23] Tonci Grgin

Closed in Bug#29098, c/NET 5.1.3+