Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    15

    Unanswered: 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 ?

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    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?

  3. #3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •