MySQL Bugs: #48783: Net 6.2 Stored Procedure Name Not Showing Up in VS 2008

Bug #48783	Net 6.2 Stored Procedure Name Not Showing Up in VS 2008
Submitted:	15 Nov 2009 19:16	Modified:	17 Nov 2009 17:47
Reporter:	King Coffee	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	6.2.1	OS:	Microsoft Windows
Assigned to:		CPU Architecture:	Any

Description:
I created a Stored Procedure in VS 2008 Connector/NET 6.2 and saved it successfully. It does not show up in VS 2008. However, it does show up in another DB management application. 

How to repeat:
I think if you install the new net 6.2.1 application and try it create and save a stored procedure in visual studio 2008, you should notice the problem.

Suggested fix:
update and release rev 6.2.2

Hi King and thanks for your report.

I tried repeating with 6.2.0 and 6.2.1 and I just cant. I was using simple procedures (no parameters and with one input parameter) similar to:
CREATE PROCEDURE `bug48783`(
IN param1 INT
)
BEGIN
  SELECT SLEEP(param1);
END

My environment:
  o MySQL server 5.1.31x64 on remote OpenSolaris host
  o MySQL c/NET 6.2.0 and 6.2.1 msi installed with "Complete" option
  o Client box with Win2K8x64 SE and both VS2005 and 2008 (Pro)

Connection string is as follows:
server=opensol;User Id=root;Persist Security Info=True;database=test;Allow User Variables=True;Functions Return String=True;Ignore Prepare=False;Respect Binary Flags=False;Use Affected Rows=True;pooling=False

Sorry, I probably did not express it clearly. The Store Proceduce is saved ok, but the VS 2008 Standard Server Explorer box shows several directories, like Tables, Views, Procedures, etc. The Procedure folder is blank. I'm running on Windows Vista.

Thanks,
King

PS: I think it did show up the first time of use... but I delete it and what's when the problems started.

King

Hi,

I'm still trying to let it to recognizes store procedures. I tried runn the program with a revsion of your connection string. I get error:

Keyword not supported.
Parameter name: allow user
   variables 

I only install the c/net code via the msi file, no other configuration action.

King

King, don't know what to say...

Check your web.config and/or app.config files, GAC and such. I retried test this morning, deleting, adding... all works just fine.
Are you running this as "root" user (all privileges) or from restricted MySQL account?

Hello Tonci Grgin,

First, I would like to give my greatest thanks for all the time and effort you gave me on this problem.

Sorry, I deleted the store procedure with a second MySql DB Management App.

My environment:
  o MySQL server 5.1.31x32 on local Vista workstation
  o MySQL c/NET  6.2.1 msi installed with "Complete" option
  o VS2008 (Std)

Since, the VS2008 (Pro) and the alternative MySQL Manager apps recognizes the c/NET 6.x store proceduces... I can only assume: VS2008 (Std) has a bug. It will save the proceduces but not load them!!!

Once again, thanks,

King

Yes, could be. I don't think standard versions are capable of loading plug-ins.