MySQL Bugs: #35956: MySQL Connector 5.2.1 + VS.Net 2005 + Stored Procedures

Bug #35956	MySQL Connector 5.2.1 + VS.Net 2005 + Stored Procedures
Submitted:	10 Apr 2008 8:40	Modified:	9 May 2008 11:55
Reporter:	R Roberts	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.2.1	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
I am using VS.Net 2005, MySQL Connector 5.2.1 etc and MySQL database 

The wizard just crashes or terminates when trying to selecting a stored procedure from the table adapter wizard. 

I have download the latest MySQLConnector from this site, has the fix not been implemented for this issue?? 

Any ideas or suggestions please? 

Thanks 

Newbie

How to repeat:
In VS.Net 2005, I tried this approach: 

Add new dataset 
go to designer 
rigth click-> Add -> TableAdapter 
select connection (or add new)->next 
check "Use existing stored procedure" -> next 
select stored procedure from list 
after selecting - wizard closed

Hi and thanks for your report. What is exact MySQL server version and do you use VS2005 Professional or Express?

I am using VS.NET 2005 - The professional edition.

Originally I was using MySQL Connector/Net 5.1.5, then yesterday I upgraded by downloading from this site - MySQL Connector/Net 5.2.1.

I still had the same problem on both versions of MySQL Connector/Net.

Thanks 

Newbie

Oh for the MySQL database - I am using SQLyog Community Edition - MySQL GUI v6.16
which I downloaded for free from the SQLYog enterprise website.

Thanks

Hi 

I just wondered if any solution has been done or implemented for this issue.

I am looking forward to a feedback on this please?

Thanks

Newbie

Hi.  As of right now the user running SP needs to have select privs on mysql.proc table. This is because MySQL does not currently provide any way to access the parameters of an SP without selecting on that table. Do you have that privilege? You can check from command line client:
mysql -uUser_ID -p -hYour_host mysql

mysql> select * from proc;

Hi

I have went onto the MySql database, I have checked on the procs table:

The stored procs names are there.

Then I went onto the procs_priv:

localhost and computer name is on there, the stored proc names are there, routine_type is "procedure", and grantor is added in and the proc_priv - I have ticked grant, alter routine and execute.

I then went to the VS2005 and clicked on XSD, and then chose existing stored procedure and selected one of them. It still does not pick it up, and it just closes the "option" window....the moment I select it from the dropdown list.

Any ideas please?

Would be appreciated.

Thanks

-

Attachment: Bug#35956.JPG (image/jpeg, text), 42.43 KiB.

--

Attachment: Bug#35956-1.JPG (image/jpeg, text), 32.18 KiB.

Hi. Working on Bug#31522 I prepared just what's needed to test your problem. Please review Reggie's post there about web.config.
Further more, as can be seen in attached images, everything works as expected. The only time I managed to get same unwanted result as you did was with malformed parameter name. I have put @inId where stored procedure clearly says it's just inId. So my conclusion is that  wizard disappearing is due to programmer error, not connector/NET.

Hi,

I have read your post and Reggie Burnett's post. So I went to the web.config and added this in:

convert zero datetime=True;ignore prepare=False;use procedure bodies=True;use old syntax=True

Then I wento the XSD, and selected "Table Adapter" and picked "Use Existing Stored Procedures. I left SELECT, UPDATE and DELETE dropdownlists blank but I selected INSERT dropdownlist, and chose a particular sproc. My sproc has CONCAT strings inside - it is a build up of INSERT and SELECT statements inside based on IF statements.
On the wizard, I can't select "Next >" or "Finish" as it is greyed out. I have posted a jpeg file so you can see it. I can't create SELECT statement as the INSERT is slightly complicated sproc based on various fields being chosen.
Is there anyway, I can bypass the "source column"?

Any ideas or suggestions would be most appreciated.

Thanks

Any ideas please?

Thanks

Bug#36623 was marked as duplicate of this report.

Hi and thanks for new info. I can assure you no one will be allowed to temper with your files. Even I can not delete them, will have to contact admins.