If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Working with stored procedures, Asp.Net with Visual Studio 2005, Connector 5.0.3

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-13-07, 01:20
fischermx fischermx is offline
Registered User
 
Join Date: Dec 2006
Posts: 15
Working with stored procedures, Asp.Net with Visual Studio 2005, Connector 5.0.3

I'm working with my sql 5.0.27, Asp.net (Visual Studio 2005) and the MySQL AB Ado.Net provider, version 5.0.3.

The thing is I can't see the stored procedures in my database. I can see my tables and make queries but not the stored, I have full permissions. When I use a 3rd party tool like CoreLab Ado.Net provider, I'm able to see the stored, so I know there was not a permission problem. The same problem occures when working with a SqlDataSource or with a TableAdapter. The list of stored procedures show up empty.

Do I need to follow any special step to work with SPs and this thing ?
Reply With Quote
  #2 (permalink)  
Old 02-13-07, 10:18
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 440
From the mysql client use:

Code:
show procedure status
to get a list of your stored procedures. Or is this not what you are looking for?
Reply With Quote
  #3 (permalink)  
Old 02-13-07, 10:42
fischermx fischermx is offline
Registered User
 
Join Date: Dec 2006
Posts: 15
Thanks, I know I can get the list that way, but that's not the point.

I'm looking for a broken or missing functionality in the Ado.Net provider by MySQL (Connector 5.0.3).
Without the dropdown box showing the storeds, I can't pick one, I can't manually type it, so I can't use them.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On