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: | |
Category: | Connector / NET | Severity: | S1 (Critical) |
Version: | 6.2.1 | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[15 Nov 2009 19:16]
King Coffee
[16 Nov 2009 8:57]
Tonci Grgin
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
[16 Nov 2009 22:06]
King Coffee
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
[16 Nov 2009 22:14]
King Coffee
PS: I think it did show up the first time of use... but I delete it and what's when the problems started. King
[17 Nov 2009 2:57]
King Coffee
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
[17 Nov 2009 8:50]
Tonci Grgin
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?
[17 Nov 2009 17:47]
King Coffee
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
[18 Nov 2009 7:18]
Tonci Grgin
Yes, could be. I don't think standard versions are capable of loading plug-ins.